Update Events in Calendar When Excel is Updated

[AliciaDG]

Hi 

I have been reading and following a couple of threads to try and make this work however i dont know what im doing wrong. 

The original flow is working. what i am trying to do is update a calender event from an google excel document. however every time i try a couple of solutions it either doesnt work or currently every hour it adds a new event. i dont want to delete the row from the excel document.

the first image is what i am unable to input as condition tab doesnt allow me to enter the code.

the second image is my current flow

[efialttes]

Hi!
My suggestion is to add empty() based expression on the left side of your condition rule.
And add expression 'true' on the right side of your condition rule, as in the following example:
https://crmtipoftheday.com/1257/learn-compose-action-in-flow/
Hope this helps

[AliciaDG]

Thanks I tried that but i dont think im doing it right. is there another way?

[v-litu-msft · Accepted solution]

Hi @AliciaDG,

So the Flow will run every hour to create a new event, what's bored you is the repeat event, right?

How about creating a column in the Excel file named "Created"? Set its value to "Yes" or "No". When a new row is added in the Excel file, set "Created" to "No". If the row has been created in Calendar event, set its value to "Yes". 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.