365 event to sharepoint list duplicate

[davilaomg]

Need help! So i have a flow set up - Office 365 - When a new event is added, updated or deleted that writes to a sharepoint list. 

This is working fine but now i have manny duplicates of each event because it adds one every time something is updated and also if someone accepts invite from what im seeing!

[UdayAdhikari]

Hi @davilaomg - try using "Is Updated" event flag as shown below (or you could also use "Is Added" event flag) to make insert/update to your SP list. This will avoid duplicates in SP list.

Let us know if you have any other questions.

Thanks

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[davilaomg]

so far so good and then when i go to test it  but updating a calendar invite - it makes those changes on everything in the list . 

can you further open your updated and create so that i can see how to solve this?

PLEASE @Anonymous 

[UdayAdhikari · Accepted solution]

@davilaomg - glad to hear that you were able to make some progress. That was a teaser, $5 to open each actions jk 🙂

Ok, I just tested on my dev tenant and got this working end to end (create to update). Give below a try and let us know if you have any further questions.

Set variable "SPEventId" to 

first(outputs('Event_found_update_the_event_in_SP_list')?['body/value'])?['Id']

Note: Follow naming conventions for prod deployment.

Thanks

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[davilaomg]

@UdayAdhikari  

This is looking promising!! might get your $10 lol

what type of variable is it - when i get down to update item it still doesnt allow me to put it in the id field. 

[UdayAdhikari]

Deal! Haha... The variable is of type string to store calendar event id which is a GUID.

[davilaomg]

getting this error - resource not found? @UdayAdhikari 

[UdayAdhikari]

@davilaomg - are you getting error on Set variable step? If so, instead of copy/paste of the expression please build it manually by matching what I provided above. Once you get pass assigning the value to the variable confirm you have correct SP list columns mapped to right values and see if it works. Keep me posted.

Thanks

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[davilaomg]

I may just be horrible at this - but im getting errors 😞 I attached screen shots - it doest even allow me to use the variable inside of the id for Update Item.  I appreciate your work here and sorry its taking a while @UdayAdhikari 

[UdayAdhikari]

@davilaomg  - I see that you copied the texts as is in "Set variable". If you check my screen capture, you will see I have first(..). You need to build the expression.

1. clear "Value" in Set variable step
2. confirm cursor is in "Value" field
3. build the expression as below

   Almost there!

Keep us posted how it goes!

Thanks

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[davilaomg]

sorry i fixed that after and the option still doesnt show up to put that as a field - is there a way of you creating a template that i can use? 

[UdayAdhikari]

Now, click on any text field in the list and select SPEventID from Dynamic content. Next, copy/cut and paste it to Id field.

Hope this help!

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.