Forum Discussion

SimonMarkEdwards's avatar
SimonMarkEdwards
Copper Contributor
Apr 01, 2021

Sharepoint button to run a Power Automate flow.

I am pulling my hair out here. (Well, what little I have left!)   I am very new to Sharepoint Online / O365.  But I have sucessfully used Power Automate to create a flow, which collects file metada...
SharePoint Online
rolanddaane's avatar
rolanddaane
Copper Contributor
Jun 20, 2021

RobElliott , Great article, and I really like your buttons!
I've been trying this, but the button shows in every row, regardless the content of the column ShareBim360.
Any idea's?


{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "button",
"txtContent": "Share to Bim360",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\": \"bce75e04-998b-4600-b829-7370d6a2ee15\",\"headerText\":\"All Things REI\",\"runFlowButtonText\":\"Publish Now\"}"
},
"style": {
"background-color": "#008082",
"color": "white",
"border-radius": "0 15px",
"visibility": "=if(([$ShareBim360] == 'Yes'),'hidden','visible')"
}
}

Thanks, Roland

ganeshsanap's avatar
ganeshsanap
MVP
Oct 14, 2022

rolanddaane What is the column/data type of "ShareBim360" column? Is it a single line of text or choice or Yes/No?

 

For choice & single line of text column, you can use: 

 

"style": {
    "display": "=if([$ShareBim360] == 'Yes', 'none', 'block')"
},

 

For Yes/No column:  

 

"style": {
    "display": "=if([$ShareBim360], 'none', 'block')"
},

 

Note:

  1. You have to use the internal name of "ShareBim360" column and not display name
  2. "ShareBim360" column be included/shown in list view.

Follow this article to get the internal name of your SharePoint column: How to find the Internal name of columns in SharePoint Online? 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources