In this blog post I will show you how to launch separate Flow based on column value. There are requirements for running separate Flows on the same list item based on the column value.
In this scenario, we will have two Power Automate Flows (i.e. Flow1 and Flow2). When a new item will be created, status will be set to draft and user can execute the Flow 1 using the Flow Launch Button which we will add to the list. Once Flow 1 is completed, status will change to approved and the same Flow Launch Button will be used to Flow2 which would you perform some other actions.
We would use Flow Launch Button using JSON formatting, please follow my blog post on Conditional Formatting on SharePoint list with Flow Button, it contains the details on how to place the JSON script to the list column and also on how to get the Flow GUID. You only need to make the conditional formatting for actionParams where you can pass the GUID for Flow1 and Flow 2 based on Status column value as shown in above top screenshot.
"actionParams": "=if([$Status]=='Approved','{\"id\": \"a04b0180-7d32-471c-8ff6-49497d229b23\"}','{\"id\": \"1f922b63-a66b-4177-9aa6-f4c37c4d6f27\"}')"
Adnan is six time Microsoft MVP (Since 2015) with over 16 years of extensive experience with major expertise on SharePoint, SharePoint based development, Microsoft 365, Microsoft Teams, .Net Platform and Microsoft BI. He is currently working Sr Microsoft Consultant at Olive + Goose. He is MCT Regional Lead for Pakistan Chapter since 2012. He is working on SharePoint for past 12 years and worked on different intranet/intranet solutions for private & govt. sector majorly in United states and Gulf region and have experience of working with multiple Fortune 500 companies. He is a trainer, technology evangelist and also speaks in community forums.
No Comments