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

(0) Share

Report

Posted on by NM-06090901-0

168

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

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'))

Was this reply helpful? Yes No
NM-06090901-0 168 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Nandit 1,568 Moderator on at

Like (0)

Report
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!

Was this reply helpful? Yes No