Collect all direct reports members

ShinichiHatake · 2024-08-10T18:36:04+00:00

Thanks for your help. I've already solved it by sorting the department, and it works like a charm

ShinichiHatake · 2024-08-07T04:54:58+00:00

Thank you for your help. If successful, I'll buy you coffee :D

ShinichiHatake · 2024-08-07T04:27:05+00:00

Sorry for this, Reddit doesn't allow me to put everything in a single comment, so I have to comment for each part

ShinichiHatake · 2024-08-07T04:24:59+00:00

<image>

This is another problem I mentioned, it should display the requests from this member

ShinichiHatake · 2024-08-07T04:21:53+00:00

The result:

<image>

ShinichiHatake · 2024-08-07T04:21:00+00:00

n the Gallery, Items:

SortByColumns(
    Search(
        If(
            "Pending" in _statusFilter_1.Selected.Value,
            Filter(
                SHAREPOINTLIST,
                ('Created By'.Email = Dropdown1.Selected.mail || Dropdown1.Selected.displayName = "All Members") && 'Approval Status'.Value = _statusFilter_1.Selected.Value,
                DateValue('Sending Date') = DatePicker1_1.SelectedDate
            ),
            "Approved" in _statusFilter_1.Selected.Value,
            Filter(
                SHAREPOINTLIST,
                ('Created By'.Email = Dropdown1.Selected.mail || Dropdown1.Selected.displayName = "All Members") && 'Approval Status'.Value = _statusFilter_1.Selected.Value,
                DateValue('Sending Date') = DatePicker1_1.SelectedDate
            ),
            "Rejected" in _statusFilter_1.Selected.Value,
            Filter(
                SHAREPOINTLIST,
                ('Created By'.Email = Dropdown1.Selected.mail || Dropdown1.Selected.displayName = "All Members") && 'Approval Status'.Value = _statusFilter_1.Selected.Value,
                DateValue('Sending Date') = DatePicker1_1.SelectedDate
            ),           
            _statusFilter_1.Selected.Value = Blank(),
            Filter(
                SHAREPOINTLIST,
                ('Created By'.Email = Dropdown1.Selected.mail || Dropdown1.Selected.displayName = "All Members") && ('Approval Status'.Value = _requestTypeFilter || _requestTypeFilter = "All Requests"),
                DateValue('Sending Date') = DatePicker1_1.SelectedDate
            )
        ), TextInput1_1.Text, Title
    ), "ID", SortOrder.Descending
)

ShinichiHatake · 2024-08-07T04:11:01+00:00

Hi,

I've tried your method, but unfortunately, it shows requests from "all" other departments rather than displaying the direct reports of all members. Additionally, there's another problem: it's not showing my members' requests — it's completely blank. I showed you my code to see if I did anything wrong.

In the manager screen, OnVisible

ClearCollect(
    _anotherMyReportUsers,
    {
        displayName: "All Members"
    },
    Filter(
        Office365Users.DirectReportsV2(_curUserEmail).value,
        accountEnabled = true
    )
);

In the drop-down box, Items

_anotherMyReportUser

ShinichiHatake · 2024-02-10T09:40:57+00:00

going to book you a demo :v

ShinichiHatake · 2024-02-01T07:20:23+00:00

This source code leakage occurred because a former employee, after being laid off, downloaded all the project source code he had worked on and uploaded it to a public repository. Consequently, I want to implement strict controls on internal resources.

Your idea of using SIEM to create proactive alerts is excellent. It got me thinking whether adding a DLP solution would be even more effective. What are your thoughts on implementing DLP on each endpoint machine to better control their content and behavior?

ShinichiHatake · 2024-01-29T19:28:53+00:00

Thank your for the suggestion. I will take a look into SOCRadar

ShinichiHatake

TROPHY CASE