cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Flows that create a calendar event whenever the column date is modified

Dear All,

I'm having troubles in genereating the flows as follows:

Item is updated / uploaded (trigger)

Create a calendar event picking the info from a "date" column of the same item.

 

The issues i have are:

  • Everytime i update an item attribute; a new event is created for EVERY item. Even those that are not modified.
  • plus would be that only when a certain attributes of the file are changed, the event is created (not essential but would be great).

My flows right now looks as follows:

image.pngPlease note that i've been forced to add the "apply to each" because otherwise i get an error from the even trigger.

And I had to add the "get item" because otherwise the "apply each" would not work.

Any clue?

 

Thank you in advance.

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Flows that create a calendar event whenever the column date is modified

Hi @sbaggio,

 

I think the first issue you encountered should be that when a new file is uploaded or created, your Flow will also trigger.

You could configure the Condition action to add a judgment. If Created is equal to Modified, then this file is newly created. The file does not execute the following action.

35.PNG

In addition, Flow currently does not support monitoring the properties of a specific file to be changed. If you want to the feature that you mentioned to be supported in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Flows that create a calendar event whenever the column date is modified

Thank you Barry! I'll let you know if I manage to solve!

Have a nice day!

Highlighted
Frequent Visitor

Re: Flows that create a calendar event whenever the column date is modified

I've tried your suggestion but still, when I update (modify) one Item, it's created a new event for each file in the library.

I need a condition that somehow select only the latest updated file and create the event ONLY for the latest file updated (modified), that is also the one that starts the trigger.

I've thought to create a condition like if the date modified equals today, then create event, yet this is not optimal because if I modify more than one file per day, it is going to create more than an event for the same item.

Any suggestion how to proper create the right condition?

Thank you.

 

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new 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!

Top Solution Authors
Top Kudoed Authors
Users online (10,481)