web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Update Button when Cli...

Power Automate

Answered

Update Button when Clicked in SP List Item

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I have a button in SP list item. when user clicks on "Send for Approval" button, it triggers the event to run Flow and send email to others. I want to update the button from " Send for Approval" to "Request Sent" when user clicks the button. That case, we will know which rows the user sent email to others and which rows the user hasn't sent email.

basically, could be an else if condition: If user clicks the button => change to "Request Sent" else 'keep the text the same as Send for Approval'

here is the code in JSON for this column.

{

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "button",

"txtContent": "Send for Approval",

"customRowAction": {

"action": "executeFlow",

"actionParams": "{\"id\": \"3bd8a3d9-311c-46ec-9c09-a2ccc2a62b8a\"}"

},

"style": {

"background-color": "#468259",

"color": "white"

}

}

Thank you

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @Anonymous I think you need a cannvas app

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,737 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

In addition to @ChristianAbata his approach you can also amend the current column formatting example and use a operator to set the visibility.

Below is an example of that.

This does require the creation of an additional choice column (Button Request Status) with the values Send for Approval and Request Sent. However, you can hide that column from your view.

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "txtContent": "Send for Approval", "customRowAction": { "action": "executeFlow", "actionParams": "{\"id\": \"3bd8a3d9-311c-46ec-9c09-a2ccc2a62b8a\"}" }, "style": { "background-color": "#468259", "color": "white", "visibility": { "operator": "?", "operands": [ { "operator": "==", "operands": [ "[$ButtonRequestStatus]", "Send for Approval" ] }, "visible", "hidden" ] } } }

Within the flow setup you can use an update item to set Button Request Status to Request Sent. This will make sure that the button is hidden.

Was this reply helpful? Yes No

Join the conversation