Show/hide buttons based on a form field value, logged in user and be able to "request access"

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have "edit" and "delete" buttons for SharePoint list items in a PowerApp. I would like to hide these buttons if the form field value of "assessment stage" is NOT "draft" AND if the current logged in user is NOT "user A" OR "user B" OR "user C" (hardcoded users who are admins). Then I'll have a "request access" button that will show if the "edit" and "delete" buttons are hidden. The "request access" will be a mailto link to an admin who will add the requested user to a person type column in a SharePoint list. The code should read from the list of users and if the current logged in user matches to one on the list, then the "edit" and "delete" should show. What would be the way to implement this and is there another/better solution?

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
In both the edit and delete buttons visible field, use something similar to this code:

*AssessmentStageField*.Update <> "draft" && ( currentUser.Email in *UsersSPList*.Email || currentUser.Email in ["UserAEmail", "UserBEmail", "UserCEmail"] )

Then, for your Request Access Button, your visible could be:

!( *AssessmentStageField*.Update <> "draft" && ( currentUser.Email in *UsersSPList*.Email || currentUser.Email in ["UserAEmail", "UserBEmail", "UserCEmail"] ) )

(the opposite of the edit/delete controls).

As for sending the email with the Request Access button, you could either call a power automate flow, or you can use the Office365Outlook data source connector to send it within your app.

Hope this helps!