Answered

Check if current user is contained in Person type field, that allows multiple selections

(0) Share

Report

Posted on by KarlXII

I have a list of projects in SharePoint, where every project gets assigned a group of multiple people in order to validate project. I need certain elements of the custom form to be visible only to people from this group, so I need to check, whether current user is part of the group. How do I do this?

Note: I already did this for the project leader (another column of the list is where the responsible person gets assigned (single selection) and likewise certain elements should only be visible to that specific individual), I put the following code under the visible property of the attachments window, which is one of the elements that are only to be visible to the leader:

User().Email = ResponsiblePersonEmail.Text

ResponsiblePersonEmail is a label with code LookUp('testni seznam', ID = Value(DataCardValue9.Text)).'Responsible person'.Email

I've tried modifying this formula for fields with multiple people, but don't really know about the specific programing language, used in PowerApps yet. Here DataCardValue9 returns the value of the ID data card of the list item.

Categories:

Building Power Apps

All responses (2)

Answers (2)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KarlXII,

To show/hide certain fields depending on a Multi-Select person field you could use the following code in the Visible properties of the corresponding DataCards:

User().Email in ThisItem.MultiPersonColumn.Email

Since the code is written within the form, you can simply leverage ThisItem. Should it be outside of the Form, use a LookUp instead.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
Verified answer

KarlXII 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Just for anyone who end up here, the code that ended up working for me was
User().Email in LookUp('testni seznam', ID = Value(DataCardValue9.Text)).'Validation group'.Email
@LaurensM 's reply did help guide me to the working solution, so I marked his answer as the accepted solution.