Unanswered

Use App Owner for the visible

(0) Share

Report

Posted on by M_Whitenight

Is it possible to use the app owners to set the visible property instead of using Or(User().email="1st owner's email", User().email="2nd owner's email", User().email="3rd owner's email").

I was hoping to be able to use something like Owner so that if someone is listed as an owner the fields hidden from the regular user are displayed.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Maxwell123 93 on at

Like (0)

Report
Copy link

Link copied!
I would try to upload an excel file with two Column The first put "Full Name" and have the second name it something like "Privilege"
I.E Below for now we will call this table reference.

Full Name Privilege
John Doe Owner
Jane Doe User

Whatever fields you need hidden you can set the visible property to something like this.

If(IsBlank(Lookup(Reference,Filename=User.()FullName,Privilege),If(Privilege="Owner",true,false),false)

The idea is that the code checks the current username of whoever is signed in and matches it with the table and then checks to see if they are an owner or not.

The good thing about an excel spreadsheet is its static and can be uploaded right to the app so it does not need to take time to check a Sharepoint list.

Let me know if this is along the lines of what your looking for and if you need help with the formula let me know.

Was this reply helpful? Yes No
M_Whitenight on at

Like (0)

Report
Copy link

Link copied!

Thanks. Your suggestion will work but I was hoping there was something directly in PowerApps so I wouldn't need to maintain two list, permissions in PowerApps and an excel spreadsheet.

Was this reply helpful? Yes No
M_Whitenight on at

Like (1)

Report
Copy link

Link copied!

Thanks Maxwell123 for your suggestion. I was hoping to have something directly in PowerApps so I didn't need to maintain two lists, the owners in PowerApps and a list in excel, if owners changed due to people leaving and coming into departments. I submitted an idea to have App.Owners added as a feature.

Was this reply helpful? Yes No