Automate create & Updating calendar event from Excel online ( once every time there is a modification or when it is recurrence

[johnosakwe]

i am having issue with creating a flow to work clean, my case it works but it creates multiple event of the same constantly looping even though its a manual trigger, I just want it to create an event if it doesn't exist in the calendar or update if it does, not to create multiple events as the same time below is my structure.  If possible for it to trigger only if the file is modified that would be great

below you can see the calendar example there are many but using one for testing 

Test excel I am using

[johnosakwe]

@Pstork1 @takolota @RobElliott 

What you guys think?

[Pstork1]

The problem is that you are looping through the Excel lines and the events.  Any time there is a mismatch its creating the new event.  Do your outer loop on the Excel Rows and then inside that do a filter array using the same condition.  If the result has a length() of 1 or more then update the event, otherwise create the event.  That should prevent duplicates.

[johnosakwe]

I think i get it but not sure how to put it in practice?

i should make a condition on "list rows present in a table" ? 

what do you mean by outer loop

You mean this 

[johnosakwe]

Think i got it like this ?

[Pstork1]

That's close.  But you need a filter array just above the condition.  Its the array that comes out of the filter that you are checking the length of.

[johnosakwe]

I see

below i am using the array its passing the information hope i am correct

maybe this one, i am sort of getting it but the flow of it is confusing me

[Pstork1 · Accepted solution]

You are back to using multiple loops again, which you don't want.  Let me try to breakdown the logic for you

1) You retrieve the list of things from Excel

2) You get the list of Events from Outlook

3) You loop through each of the rows in Excel

        a) Filter the array retrieved from Outlook by comparing the Title to the Title of the Event

        b) Check to see if the filter returned one or more records.

                >0 - The Event exists.  loop through the array returned by the filter and update each one using the details from the current Excel Row. There should normally be only one

                 =0 - The Event doesn't Exist. Use the current excel row to create a new Event. 

other than adding the filter array and changing the condition etc, that is what you had in the post I last responded to.  This current post added a bunch of new loops that makes things worse.

[johnosakwe]

here is now the current one 

when i run it i get the error below 

seems to break when it goes to the create event 

[johnosakwe]

Realised my mistake it was the start date and end date, it was fom 30/06/2022 and the end date was 22/06/2022 corrected it now it run all of them

[Gurinder_P_SIng]

I am following this thread but I am getting the error "ActionFailed. An action failed. No dependent actions succeeded.", could you please guide why I am getting BadRequest , why dependent action is not getting success.   

 

[Pstork1]

Please post this as a new question.  You'll get more responses and others will be able to find the answer more easily later.