Answered

How to create event from an Excel to Calendar without duplicate events

(0) Share

Report

Posted on by SergioNRP

How to create events from an excel to Calendar using PowerAutomate flow, with daily updates, without duplicating events...

This is what I've tested it, but isn't working, since it still creates duplicate events every time the action runs...

from the excel I have set a subject, Start date, end date, description.

Screenshot 2021-08-11 at 14.00.53.png

any help?

P.s.: took this setup from another article.

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @SergioNRP

Your filter will always have length 0 and will therefore always create an event. You might be looking to see if the body contains the description, but not the description containing the body. Try swapping those two dynamic values about and use the contains function instead.

The condition length is equal to 0 is correct. I.e. if the filter returns 0 matches, create an event.

I did a video about creating events, albeit it's based on a MS Form submission.

Hope that gets you sorted.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
SergioNRP 10 on at

Like (0)

Report
Copy link

Link copied!

I've tried that, but doesn't seem to work...
tried some of your functions, but not lucky here either.

added the update event logic, if the field isn't empty... but doesn't seem to work either, since the only thing it does is create new events, making them duplicated...

any suggestions?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@SergioNRP

i don’t think you’ve understood. Your filter is the wrong way around. Your body will presumably contain the description BUT you’re checking if the description contains the body. It won’t. It never will. So the condition will always evaluate to true.

Change the filter to check for the body containing the description.

You should be able to manually check this (literally look at the output of the get events) from the history.

Damien

Was this reply helpful? Yes No
SergioNRP 10 on at

Like (0)

Report
Copy link

Link copied!

hi @DamoBird365 ,
sorry if this sounds too amateur... but is true...
you mean this way, correct?

if so, the automation still duplicates all events...
what I want to achieve is to get an event list on excel, with a daily update to check for new entries and populate my calendar with that or update any changed events...

This was looking great a solutions, due to the automatisation, but isn't easy to understand from the start...
really appreciate your help on this one... thank you.

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @SergioNRP

I've had a proper look at this one and as the body is an array, the filter array will still always return a length of 0. So, the correct setup is going to be Subject is equal to Description. Something like:
So when I run my version, I get a match and the length will therefore be > 0 as the output of the filter contains an event with a subject matching "PowerBI".

Something to note, the condition is equal to is Case Sensitive, therefore you need to ensure that the excel sheet matches the subject in the event by CaSe. Alternatively, you can wrap tolower() around both expressions in the condition.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
SergioNRP 10 on at

Like (1)

Report
Copy link

Link copied!

is working now, much appreciated!

Was this reply helpful? Yes No