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:
Where "DataCardValue30" is the name of your manager field.
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:
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: