Start an approval flow when a SharePoint list item is modified

[AdamInLondon]

Hello I am trying to create a Flow based on a SharePoint List

I want to trigger an approval flow when an existing item in a SharePoint List is modified.

Heres how I want it to work:

1. The user will create a Change Request item in a SharePoint List.

2. One of the columns in the List is called "Change Control Status" and this can have a value of:

• DRAFT

or

• SUBMITTED

3. If the value is DRAFT - do nothing

4. If the value is changed to SUBMITTED then start an Approval Flow to notify managers that they need to review the change and approve or reject it.

The problem is I cant get it to run, It says it was succesful but nothing happens. 

The Approval is Assigned  to one email address, my own

Cananyone help?

This is how it looks:

 

[ScottShearer · Accepted solution]

@AdamInLondon 

I assume that the Flow runs but the condition always equates to false so the approval never gets started.

Is the Change Control Status column a choice column?  If so you should be referencing the Change Control Status Value (rather than Change Control Status) from Dynamic properties on the left side of your condition.

Also, you probably want a third status for the Change Control Status column.  If you don't then the approval will run again when the item is updated to reflect the fact that it was approved or rejected.

[AdamInLondon]

Hello Scott thank you, as you suggested I changed the Condition to "ChangeControlStatus Value" and the flow now sends the approval email! 

I am new to this so thanks again.

With reference to your comment about a third status Im not quite sure what you mean. The Column currently has three Choices:

DRAFT

COMMENTS

SUBMITTED

I will be adding another Flow to send notifications to a different group of users when the Staus is changed from DRAFT to COMMENTS

Adam.

[v-bacao-msft]

Hi @AdamInLondon ,

I agree with Scott, please check the Flow run history to see if the result of Condition judgment is true or false.

If the "Change Control Status" type of Choice, you need to use Choice value as a parameter in the Condition. Like:

Hope this helps.

Best Regards,

[AdamInLondon]

Thanks too to Barry, you are right.

Adam.