web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Adding Additional Filt...

Power Apps

Suggested Answer

Adding Additional Filter Criteria to Microsoft Entra IDs Formula

(0) Share

Report

Report

Posted on by Appleonwindows

129

Hi all,

I need some assistance with a formula I'm using in my Items property to filter a list of persons in my Microsoft Entra IDs. The current formula is as follows:

Filter(Choices([@'Table1'].'SubmitttedUser'),'User Type'="Member")

This formula filters the list to show only those with the 'User Type' equal to "Member". However, there is still a lot of noise, and I would like to add an additional criterion to filter out everything that ends with "@gmail.com".

Could someone please help me modify this formula to include this additional filter?

Thank you in advance for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

jpespena 335 on at

Like (0)

Report
Copy link

Link copied!
Hi,

You can add the additional filters in your Filter function like this:

Filter(Choices([@'Table1'].'SubmitttedUser'),'User Type'="Member", "@gmail.com" in 'Email Field', Status = "Open")

If my post helped resolve your issue, please click Accept as Solution—this helps others find it more easily and marks the item as closed. If you found this or my previous reply helpful, a Like would also be appreciated!

Was this reply helpful? Yes No

Join the conversation