Unanswered

Start flow based on the "created by" field

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Msdebhel 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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-differentiate/idi-p/132966

Best regards,

Mabel

Was this reply helpful? Yes No