Start flow based on the "created by" field

[Msdebhel]

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

[v-yamao-msft]

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.

 

Best regards,

Mabel

[Msdebhel]

Hi  V-yamao-msft

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.

[v-yamao-msft]

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