cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sbaggio
Level: Powered On

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
Community Support Team
Community Support Team

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.
sbaggio
Level: Powered On

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!

sbaggio
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 448 members 6,781 guests
Please welcome our newest community members: