I've working on a Flow to generate my team's morning email, which has a section on who is out that day. It pulls this info from our shared Out calendar, where staff add an all-day event with their name in the subject field. The Flow is working as expected, but I've noticed that almost every day there will be one event duplicated. The last three days, it has been a different staff member each day.
When I look at the calendar, I do not see duplicate events for these staff members. There are some multi-day events scheduled, but these are not the ones showing up twice in my email, so I don't think it's related to the timeframe used to look for events. It does seem to be people who scheduled to be out sick on the same day, so I'm thinking they might be scheduling from their phones.
When I look at the Flow run history, it is showing the duplicated event as having a slightly different ID and *very* slightly different Date TimeCreated and DateTimeLastModified.
I'll share today's example below, with the organizer and name redacted. Any thoughts on what could be going on with the calendar, or ideas of how to get rid of the duplicates in the Flow?
{
"Subject": "MK - Sick - FMLA ADA",
"Start": "2019-08-29T00:00:00.0000000+00:00",
"End": "2019-08-30T00:00:00.0000000+00:00",
"ShowAs": "Free",
"Recurrence": "None",
"ResponseType": "Organizer",
"ResponseTime": "0001-01-01T00:00:00+00:00",
"Importance": "Normal",
"Id": "AAMkAGIxNTI1ODllLTRlNTYtNDUzZS1hZDU2LTE0YTgzNjhmYjVmZgBGAAAAAAAkVnE7M1f5TrzEFN6J53GZBwCMaEHEJBUaRqiwRHCnw1bNAAGRYRyDAACMaEHEJBUaRqiwRHCnw1bNAAHqoFzeAAA=",
"DateTimeCreated": "2019-08-29T11:20:11.2604125+00:00",
"DateTimeLastModified": "2019-08-29T11:20:12.623641+00:00",
"Organizer": "-----",
"TimeZone": "UTC",
"SeriesMasterId": null,
"Categories": [],
"RequiredAttendees": "",
"OptionalAttendees": "",
"ResourceAttendees": "",
"Body": "<html><head><meta name=\"Generator\" content=\"Microsoft Exchange Server\">\r\n<!-- converted from text -->\r\n<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style></head>\r\n<body>\r\n<font size=\"2\"><span style=\"font-size:11pt;\"><div class=\"PlainText\"> </div></span></font>\r\n</body>\r\n</html>\r\n",
"IsHtml": true,
"Location": "",
"IsAllDay": true,
"RecurrenceEnd": null,
"NumberOfOccurrences": null,
"Reminder": null,
"ResponseRequested": true
},
{
"Subject": "MK - Sick - FMLA ADA",
"Start": "2019-08-29T00:00:00.0000000+00:00",
"End": "2019-08-30T00:00:00.0000000+00:00",
"ShowAs": "Free",
"Recurrence": "None",
"ResponseType": "Organizer",
"ResponseTime": "0001-01-01T00:00:00+00:00",
"Importance": "Normal",
"Id": "AAMkAGIxNTI1ODllLTRlNTYtNDUzZS1hZDU2LTE0YTgzNjhmYjVmZgBGAAAAAAAkVnE7M1f5TrzEFN6J53GZBwCMaEHEJBUaRqiwRHCnw1bNAAGRYRyDAACMaEHEJBUaRqiwRHCnw1bNAAHqoFzfAAA=",
"DateTimeCreated": "2019-08-29T11:20:11.2604126+00:00",
"DateTimeLastModified": "2019-08-29T11:20:12.7155889+00:00",
"Organizer": "-----",
"TimeZone": "UTC",
"SeriesMasterId": null,
"Categories": [],
"RequiredAttendees": "",
"OptionalAttendees": "",
"ResourceAttendees": "",
"Body": "<html><head><meta name=\"Generator\" content=\"Microsoft Exchange Server\">\r\n<!-- converted from text -->\r\n<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style></head>\r\n<body>\r\n<font size=\"2\"><span style=\"font-size:11pt;\"><div class=\"PlainText\"> </div></span></font>\r\n</body>\r\n</html>\r\n",
"IsHtml": true,
"Location": "",
"IsAllDay": true,
"RecurrenceEnd": null,
"NumberOfOccurrences": null,
"Reminder": null,
"ResponseRequested": true
},
Thank you very much for this workaround! My Flow had no duplicate events this morning, but if it happens again I will give your filter a try.
Hi @schenley ,
At present, I am afraid it is hard to analyze the cause of this problem, but according to your situation, if you get the duplicate events with the same subject, you could consider obtaining a unique event based on the subject.
Image reference:
Please take a try.
Best Regards,