cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
naijacoder
Helper IV
Helper IV

How to retrieve a column field to use in actionParams when using a format action in JSON - MS FLOW

I'm working on have to trigger ms flow from a link in sharepoint via the modern UI list.
I can trigger the link and it fires the flow but instead of hardcoding the flow GUID i want to store them in a field in SharePoint and pass it in as an action parameter in the JSON.
Is this possible?

See screenshot below of the JSON for custom formating

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "span",
  "style": {
    "color": "#0078d7"
  },
  "children": [
    {
      "elmType": "span",
      "attributes": {
        "iconName": "Flow"
      }
    },
    {
      "elmType": "button",
      "style": {
        "border": "none",
        "background-color": "transparent",
        "color": "#0078d7",
        "cursor": "pointer"
      },
      "txtContent": "Start Flow",
      "customRowAction": {
        "action": "executeFlow",
         //How can i pass a column field name here to the ID instead of the hardocded GUID(intstead the GUI will be coming from a SharePoint list?)
        "actionParams": "{\"id\": \"c42f9124-653d-468a-8178-07063e5f5c88\"}"
      }
    }
  ]
}

Thanks in advance

3 REPLIES 3
naijacoder
Helper IV
Helper IV

Any help on this.

How can i do something like this below. I want to store the Flow ID's in a list and use it on the actionParams

"actionParams": "{\"id\": \"$ColumnName\"}"

I tried it but it didn't work 😞

 

  "customRowAction": {
        "action": "executeFlow",
         //How can i pass a column field name here to the ID instead of the hardocded GUID(intstead the GUI will be coming from a SharePoint list?)
        "actionParams": "{\"id\": \"c42f9124-653d-468a-8178-07063e5f5c88\"}"
      }
    }

 

v-bacao-msft
Community Support
Community Support

Hi @naijacoder,

 

Could you share all the screenshots of your Flow configuration?

I don't know how to create the column you describe. If you can provide some hints, it is more convenient for us to understand your needs.

It seems that you want to extract some specified content from the acquired data. Could you provide an example?

If you could share a specific method of creating a similar column, maybe we can find the right workaround for you.

Please provide more details.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks  

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,591)