I have a button on my PowerApps form that I am going to use for manager approval for records in a SharePoint list. However when I load the form I only want the button to show if the record status is "Created" and the Approving Manager matchs the manager logged onto the app.
I assume this would be in the OnVisible property of the screen and I have tried an IF statement to no effect.
Any help would be appreciated.
Hi @megbert ,
You likely need to use a property (such as Email) to accomplish this. Try setting the "Visible" property of your button to something like:
If(User().Email=DataCardValue30.Selected.Email,true,false)
Where "DataCardValue30" is the name of your manager field.
Joey
Hi @megbert,
Could you please share a bit more about your app's configuration?
Could you please show a bit more your SP list?
I assume that there is a Status column (Single line of text type column) and a ApproverManager column (Person or Group type column) in your SP list, I have made a test on my side, please take a try with the following workaround:
Set the Visible property of the Button control (Approve Button) to following formula:
If(DataCardValue3.Text="Created"&&DataCardValue4.Selected.Email=User().Email,true,false)
Note: The DataCardValue3 display the value of Status column, the DataCardValue4 display the value of the ApproverManager column.
If the Status column is a Choice type column in your SP list, please modify above formula as below:
If(DataCardValue3.Selected.Value="Created"&&DataCardValue4.Selected.Email=User().Email,true,false)
Best regards,
Kris
Thank you! I will give that a try as soon as I am able to get back to my project.
User | Count |
---|---|
197 | |
122 | |
89 | |
48 | |
41 |
User | Count |
---|---|
286 | |
162 | |
138 | |
80 | |
73 |