cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Powerapps - People Picker - This formula uses scope

Hi,

I have a button in my gallery (connected to  SP List) ... I want to show the button if the current login user is Project Manager (Project Manager is people Picker column in my SP List)... I used the below condition on the visible property of the button ...

However I am not able to execute this .. its giving me a message that "This formula uses scope, which is not presently supported for evaluation" ... please help me on this. ....

 

If(ThisItem.PROJ_QE.Email = User().Email, true, false)

 

PROJ_QE -- Project Manager People picker column. 

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

Hi @Anonymous ,

 

Is the Project Manager person column in the same list as the data source of the Gallery?

 

If it is, you'd better use another Lower function to eliminate the interference of case. Below are the steps:

1. OnStart of the App:

Set(varEmail,Lower(User().Email))

vjefferni_1-1635924542350.png

 

2. Visible of the button inside the Gallery:

If(
    Lower(ThisItem.'Project Manager'.Email) = varEmail,
    true,
    false
)

vjefferni_2-1635924610220.png

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

 

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

2 REPLIES 2
cchannon
Super User
Super User

Check to make sure your picker and your user data both display properly on the form. If they both resolve cleanly (i.e. data types match and are simple), this should not be an issue.

v-jefferni
Community Support
Community Support

Hi @Anonymous ,

 

Is the Project Manager person column in the same list as the data source of the Gallery?

 

If it is, you'd better use another Lower function to eliminate the interference of case. Below are the steps:

1. OnStart of the App:

Set(varEmail,Lower(User().Email))

vjefferni_1-1635924542350.png

 

2. Visible of the button inside the Gallery:

If(
    Lower(ThisItem.'Project Manager'.Email) = varEmail,
    true,
    false
)

vjefferni_2-1635924610220.png

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

 

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,948)