Show Button based on record status and user id.

[megbert]

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.

[keathley]

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

[v-xida-msft]

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

[megbert]

Thank you!  I will give that a try as soon as I am able to get back to my project.