Answered

Update Events in Calendar When Excel is Updated

Like (0) Share

Report

Posted on 14 Apr 2020 11:18:05 by AliciaDG

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 unable to add this.PNG

Social media info.PNG

All responses (3)

Answers (1)

Verified answer

v-litu-msft on 15 Apr 2020 at 06:07:09

Like (0)

Report

Re: Update Events in Calendar When Excel is Updated

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.
AliciaDG 93 on 15 Apr 2020 at 05:58:59

Like (0)

Report

Re: Update Events in Calendar When Excel is Updated

Thanks I tried that but i dont think im doing it right. is there another way?
efialttes 14,756 on 14 Apr 2020 at 11:31:06

Like (0)

Report

Re: Update Events in Calendar When Excel is Updated

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