Answered

Update Button when Clicked in SP List Item

(0) Share

Report

Posted on by Community Power Pla...

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:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @Anonymous I think you need a cannvas app

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
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