Apr 18 2024 11:37 AM
For SharePoint list formatting, is it possible to have a column that contains a button in each row to where if you select the button, a dropdown list of options appears where you can select an option from the dropdown list to initiate a power automate flow?
Mockup example:
Apr 18 2024 12:47 PM
Solution@Denvermartin no, you would need to have 3 columns, each a single of text column with a JSON-formatted button in each that triggers the relevant flow.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Apr 18 2024 02:02 PM
@Rob_Elliott One work around that's not a dropdown list, but you can have multiple buttons in a cell if you aren't wanting to create multiple columns.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"style": {
"display": "flex",
"flex-direction": "row"
},
"children": [
{
"elmType": "button",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\":\"INSERT FLOW CODE HERE\",\"option\":\"Option 1\"}"
},
"attributes": {
"class": "ms-fontColor-themePrimary ms-fontColor-themeDarker--hover"
},
"style": {
"border": "none",
"background-color": "transparent",
"cursor": "pointer"
},
"children": [
{
"elmType": "span",
"attributes": {
"iconName": "FolderHorizontal"
},
"style": {
"padding-right": "6px"
}
},
{
"elmType": "span",
"txtContent": "Add a folder"
}
]
},
{
"elmType": "button",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\":\"INSERT FLOW CODE HERE\",\"option\":\"Option 2\"}"
},
"attributes": {
"class": "ms-fontColor-themePrimary ms-fontColor-themeDarker--hover"
},
"style": {
"border": "none",
"background-color": "transparent",
"cursor": "pointer"
},
"children": [
{
"elmType": "span",
"attributes": {
"iconName": "Edit"
},
"style": {
"padding-right": "6px"
}
},
{
"elmType": "span",
"txtContent": "Edit"
}
]
}
]
}
And if that's not an option, then use power apps to customize a form?
Apr 18 2024 12:47 PM
Solution@Denvermartin no, you would need to have 3 columns, each a single of text column with a JSON-formatted button in each that triggers the relevant flow.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)