Adding Additional Filter Criteria to Microsoft Entra IDs Formula

(0) Share

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 (1)

Answers (0)

Suggested answer

jpespena 335 on at

Like (0)

Report
Adding Additional Filter Criteria to Microsoft Entra IDs Formula

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