cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Start flow based on the "created by" field

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.

 

User1,user2,user3

If amount= 500

Assigned TO A(static)

User4,user5,user6,user7

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?

 

 

Thank you

 

 

 

 

 

 

 

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Start flow based on the "created by" field

Hi @Msdebhel,

 

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.

 1.PNG2.PNG3.PNG

 

 

Best regards,

Mabel

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

Re: Start flow based on the "created by" field

Hi  

 

 

 

 

 

Highlighted
Community Support
Community Support

Re: Start flow based on the "created by" field

Hi @Msdebhel,

 

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:

https://powerusers.microsoft.com/t5/Flow-Ideas/Flow-to-recognise-column-value-is-changed-and-differe...

 

Best regards,

Mabel

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,672)