Unanswered

Help with approval flow if field has been changed in SharePoint List.

(0) Share

Report

Posted on by derk

Hello, I have a calendar list in SharePoint with an approval flow attached to it that if the user accepts the approval it marks the status of the item to Accepted. Now if for some reason the date was changed on the list item in the calendar I would like to start another approval process via email so the end user could accept the new date. I see Flow doesn't have the when an item has been modified connector anymore but it has when a new item is created or modified. What would be the best to use this connector to accomplish this?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-yuazh-msft on at

Like (0)

Report

Hi @derk,

The trigger "When an item is modified" is not supported in sharepoint connector in microsoft flow currently.

If you want to trigger an flow when an item is modifed, you could only use the trigger "When an item is created or modified".

As an alternative way, you could:

1. Add a Yes/No type column "DateIsChanged" in the list, the default value of column "DateIsChanged" is false.

2. Everytime when create an item in the list, keep the column "DateIsChanged" be false.

3. Everytime when change the date in the list, keep the column "DateIsChanged" be true.

4. Create a flow with trigger "When an item is created or modified", add a Condition to check if the "DateIsChanged" column value is equal to true, in the If yes branch of the Condition, add the approval action for date changed, In the If no branch of the Condition, add the approval action for new item created.

Best regards,

Alice

Was this reply helpful? Yes No
derk 46 on at

Like (0)

Report

Hi @v-yuazh-msft Alice,

Would the DateIsChanged field be something the user changes manually when they change the date?

Was this reply helpful? Yes No
derk 46 on at

Like (0)

Report

Would I set to set up a variable in the flow to accomplish this?

Was this reply helpful? Yes No