I have created a flow that starts when a new item is created and I have added a condition which trigger the approval process ,(if field "amount" is equals or less xxx). So far so good.
Question: Now I need to initiate 2 different flows(or 1 flow if it is possible) for the same condition (if field "amount" is equals or less xxx) depends on who is the "created by" , so the 2nd flow will be for another specific "Assigned TO" approver which will be a static person.
Approval process for approve “Assigned TO” depends on the specific 'user email' who is the ‘created by’ field.
For example , If user A (created by) create an item in list then start 1st flow for approval ,else start the 2nd approval.
Lets explain more using the following table.
If amount= 500
Assigned TO A(static)
If amount= 500
Assigned TO B (static)
I have added also the users (1,2,3,4) and (4,5,6,7) in 2 separate groups in SharePoint site/list in order to use them in flow process, although I can’t find the solution for that.
Can you please advise what is the optimum solution for that business need?
According to your description, I have made the following flow.
It is triggered by When an item is created in SharePoint list.
Initialize variable Group1, set Type as String, Value as [‘Test2’,’Test4’].
Initialize variable Group2, set Type as String, Value as [‘mabel mao’,’Test3’]
Note: Test2, Test4, mabel mao, Test3 are DisplayNames of the user.
Add a parallel branch, under each branch, add the following steps.
A Condition to check if the Number is less than or equal to 500. Under If yes branch, add Condition2 to check if Group1 contains Created by DisplayName which is returned from the trigger.
If yes, start an approval email.
Note: The same configuration under another branch.
Following images for your reference.
Thank you very much for your quick response. The flow that you sent me works prefect!!!
Athough I would also to add one more parameter in my scenario. I need to start the flow only when the item changes a choice column to a status with Value 'Submit' . So its a kind of tricky, because I dont want to start the flow when the item is created but I need to start the flow when a specific column has a specific value ( Submit value)
Ιn conclusion when a user creates an item, aftertaht must edit the item and change a column for the default value 'Pending' to value 'Submit' in order to initiate the workflow.
Thank you in advance.
I assume that you could try to use the trigger When an item is created or modified. Then add a Condition to check if the specific column contains specific value. If yes, do the following actions. If no, do nothing.
Besides, currently it is not possible to monitor a flow when a single column value is changed, I have seen a similar request, please vote the idea at here:
Find your favorite faces from the community presenting at the Power Platform Community Conference!
Check out the announcement of Power Platform content at Microsoft Ignite!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021