Filter is now working in table

(2) Share

Report

Posted on by Saran S

Hi Guys,

I have a screen, in that i filtered the users based on the hierarchy, but it not working

Screen - OnVisible property:

code:

ClearCollect(
    colReportees,
    Office365Users.DirectReports(User().Email)
);

Table - Items property:

code:

Filter(
    ReimbursementTables,
    'Request status' <> "Draft" && 
    'Employee mail id' in ForAll(
        colReportees, Mail)
)

Is anyone have an idea about this issue?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Saran S,

I assume you have looked in colReportees and ensured that the correct dataset in in there - your code looks correct to get this data for the staff reporting to the user.

You did not state your data source type or whether you were getting any errors, but possible Delegation issues aside and assuming that the 'Employee mail id' field in ReimbursementTables contains the case-sensitive email of the target user/s, then this should work
Filter( ReimbursementTables, 'Request status' <> "Draft" && 'Employee mail id' in colReportees.Mail )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Saran S,

ClearCollect(

    colReportees,

    Office365Users.DirectReports(User().Email)

);

ClearCollect(

    colReporteeMails,

    ShowColumns(colReportees, 'Mail')

);

Items

With(

    { reporteeMails: colReporteeMails.Mail },

    Filter(

        ReimbursementTables,

        'Request status' <> "Draft" &&

        'Employee mail id' in reporteeMails

    )

)

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Verified answer

Saran S 21 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @WarrenBelz and @MS.Ragavendar,

Thanks for your replies.

I found and fixed the issue. It was related to roles — the user did not have access to the Dataverse table.

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Saran S,

I suspected something else, but wanted to make sure all my assumptions were correct and that a simplified version of the code worked (or not)

Was this reply helpful? Yes No
Saran S 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

The code which you given working fine.

Thanks.

Was this reply helpful? Yes No