Answered

Update SharePoint list Item when Outlook event modified flow not working

(0) Share

Report

Posted on by Ghada Mehrez

257

Kindly any support I created this flow to update SharePoint list Item when Outlook event modified it gives Flow run successfully but the list is not updated when the event updated.

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@gme-eg

Your screen shot indicates that you are trying to find an item in a SharePoint list by matching the list item ID to the event ID. This will not work - they are not related.

I suggest adding a column to the SharePoint list called EventID. When an event is created, created an item in the SharePoint list and store the ID of the event in the Event ID column. Then, try to match EventID in your OData filter.

Let me know if you need more help.

Was this reply helpful? Yes No
Ghada Mehrez 257 on at

Like (0)

Report

Thanks a lot, I added the Event ID Column to the SharePoint list (Number type) and I got this error to the flow when the outlook event created, add SharePoint list, any advice on how to solve it

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@gme-eg

Flow appears to be complaining about the data type of the data type of the Event ID column in SharePoint. Is it a number?

Was this reply helpful? Yes No
Ghada Mehrez 257 on at

Like (0)

Report

yes it is number

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@gme-eg

My error - change the data type of the SharePoint column to single line of text and try again.

Was this reply helpful? Yes No
Ghada Mehrez 257 on at

Like (0)

Report

I changed it into a single line but I got the same error
Note that my SharePoint list is a calendar, It has an ID column I don't know if this may help.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@gme-eg

I will provide an example Flow - may not have time until tomorrow....

Was this reply helpful? Yes No
Ghada Mehrez 257 on at

Like (0)

Report

Thanks appreciated

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@gme-eg

In my example below, I have a SharePoint calendar. I added a text column called "OtherCalID". When a new item is created in the Exchange calendar, I add an entry to my SharePoint calendar and insert the Exchange event Id into the OtherCalID column. I can use these columns in an OData filter.

Was this reply helpful? Yes No
Ghada Mehrez 257 on at

Like (0)

Report

For the create Item it works fine but I still have the error when I update outlook event the SharePoint item is not updated

Was this reply helpful? Yes No