Check for User() in a Multi-Select Person/Group column

(0) Share

Report

Posted on by NM-06090901-0

109

I need to create a filter that checks if the logged in users email is included in a multi select person column

LookUp('Apointment Calendar',User().Email in 'Technician Assigned')
 
Something similar with the above(although this does not work) where Technician Assigned might have more that one value and its a person column
 
Can someone shed some light on how to do this?

Categories:

Using Apps Using Formulas

All responses (3)

Answers (1)

Verified answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report
Check for User() in a Multi-Select Person/Group column

Hi NM-06090901-0,

I have added a Text label on the screen which displays a Yes or No based on if the person exists in the person column:

With( {Records: 'Apointment Calendar'}, If(!IsBlank(LookUp( Records, User().Email in 'Technician Assigned'.Email) // you can even look up a selected item or filter by ID ), "Yes", "No" ))

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!
NM-06090901-0 109 on at

Like (0)

Report

Check for User() in a Multi-Select Person/Group column

Sorry i have used the wrong forum for my question.I have already edited the post.

Just to clarify !! I need to do this in Power Apps only

Thanks
Suggested answer

David_MA 10,554 Super User 2025 Season 1 on at

Like (0)

Report

Check for User() in a Multi-Select Person/Group column

Put the people field into a Filter array action and then filter the Email field on the person you are looking for:

To get the value in the left side of the filter, you need to use the expression builder and enter item()?['Email']. Note, the filter is case-sensitive and that the dynamic value in the From field is your people field that does not return the e-mail, display name, etc.

You can then use a condition to see if the value was found:

This is the expression on the left side of the condition: empty(body('Filter_array'))