cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
derk Helper I
Helper I

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

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?
3 REPLIES 3
Community Support
Community Support

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

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

Highlighted
derk Helper I
Helper I

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

Hi @v-yuazh-msft Alice,

 

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

derk Helper I
Helper I

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

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

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (4,978)