Error happened_ Visible setting based on other column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi The powerapp is connecting 2 share point list as the data source.

The first list data is used for main screen.

There is one Field I want it only visible when the user is Admin.

The other list is the Admin list.

User is Person/group column, Person is Text with mail address.

I set App OnStart

Set(varUserEmail, User().Email);
If(CountRows(Filter('AppAdmins',varUserEmail in Person)) > 0,Set(varUserAssignee,true),Set(varUserAssignee,false));

However there is warning message as below:

I would like to confirm how to resolve it.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

This should do the whole process assuming Person is a Text field

Set( varUserAssignee, !IsBlank( LookUp( 'AppAdmins', Person = User().Email ).Person ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz Thank you very much! But the error happens as below.
Could you please kindly tell the reason?

Was this reply helpful? Yes No
WarrenBelz 155,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

That is the field name you provided in your code - how can it not be valid now? What type of field is Person in your AppAdmins list ?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, Person is Text column with mail address.

Was this reply helpful? Yes No
WarrenBelz 155,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I am rather confused here - your original code

If( CountRows( Filter( 'AppAdmins', varUserEmail in Person ) ) > 0, Set( varUserAssignee, true ), Set( varUserAssignee, false ) );

simply showed a Delegation warning on the in filter (as expected), but now you are saying that this Text column in the list AppAdmins called Person which is valid above is not valid in

Set( varUserAssignee, !IsBlank( LookUp( 'AppAdmins', Person = User().Email ).Person ) )

Below is a test I did on a list here where EmailAddress is a Text field in Users

with the result (I am in the list)

Have you changed the field name from something else here ?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No