Answered

365 event to sharepoint list duplicate

(0) Share

Report

Posted on by 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!

Categories:

General topics

I have the same question (0)

All responses (11)

Answers (1)

UdayAdhikari 450 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
davilaomg 14 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

UdayAdhikari 450 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
davilaomg 14 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
UdayAdhikari 450 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
davilaomg 14 on at

Like (0)

Report
Copy link

Link copied!

getting this error - resource not found? @UdayAdhikari

Was this reply helpful? Yes No
UdayAdhikari 450 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
davilaomg 14 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
UdayAdhikari 450 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@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.
clear "Value" in Set variable step
confirm cursor is in "Value" field
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.

Was this reply helpful? Yes No
davilaomg 14 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No