Forum Discussion
Solved
Start Power Automate Flow from Button in Footer
Hi!
In my Sharepoint Form that opens from my List-Element, I want to integrate a Button that starts a Workflow.
{
"elmType": "div",
"style": {
"width": "100%",
"text-align": "left",
"overflow": "hidden",
"border-top-width": "1px"
},
"children": [
{
"elmType": "div",
"style": {
"width": "100%",
"padding-top": "10px"
},
"children": [
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "button",
"style": {
"backgroundColor": "#fefbd8",
"borderRadius": "8px",
"borderStyle": "none",
"boxSizing": "border-box",
"color": "#f18973",
"cursor": "pointer",
"display": "inline-block",
"fontFamily": "\"Haas Grot Text R Web\", \"Helvetica Neue\", Helvetica, Arial, sans-serif",
"fontSize": "14px",
"fontWeight": "500",
"height": "40px",
"lineHeight": "20px",
"listStyle": "none",
"margin": "0",
"outline": "none",
"padding": "10px 16px",
"position": "relative",
"textAlign": "center",
"textDecoration": "none",
"transition": "color 100ms",
"verticalAlign": "baseline",
"userSelect": "none",
"WebkitUserSelect": "none",
"touchAction": "manipulation",
"visibility": "=if(([$Status] == 'Überprüft und finalisiert'),'hidden','visible')"
},
"txtContent": "=if(([$Status] == 'offen'), 'Erstellung erfolgt', if(([$Status] == 'Erstellung erfolgt'), 'Überprüft und finalisiert', 'Nonvisible'))",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\": \"972013a1-fd18-4457-ab9f-83659da9fbc1\"}"
}
}
]
}
]
}
Is this even possible? All I found where solutions that integrated the Button in a column.
Thanks so much for any help!
Modify the VLOOKUP by adding IFERROR. The correct syntax is illustrated here.
=IFERROR(VLOOKUP($A5,Source,2,0),"")
Please also understand that the answers we've given you are not the only way to accomplish something like this. One of the wonders of Excel is that there are always multiple routes to the same destination; which of those routes is ideal can depend a lot on the bigger picture. What @Riny_van_Eekelen and I have demonstrated here are a couple of the more basic ways to retrieve a value from another table.
1 Reply
EVMS_ Unfortunately, it is not supported in JSON used in header/footer layout of list forms.
customRowAction (executeFlow) is not supported in list form JSON formatting.
Similar thread: Add Button to SharePoint Form JSON
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.
