I’ve created an approval flow using a sharepoint calendar when a new item is created and then once approved by the manager a copy of the approved request is exported to an excel table, the problem is when someone selects “all day event” option it exports into excel with the incorrect start date but correct end date. I’ve tried converting time zones from UTC, but still doesn’t seem to work. See below the conversion portion of the flow and the excel results it produces.
I then use the converted times to be exported to excel, just didn’t capture a screen shot of that.
The event that was created on the calendar was for an all day event on 8/28 but when it gets exported to excel it displays 8/27 with a random time and 8/28 with another random time.
Did you end up finding a solution to this or are you still experiencing the issue. If it's still an issue, I'll endeavour to run through creating this and finding us a solution if still outstanding. Thanks for your direction.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.