Forum Discussion
Power Automate generates agenda entry at wrong time
Hi Bernd Kroon
Based on your description, here's a few things to consider:
Your first question
1. Make sure that the SharePoint site regional settings are correctly configured as it can mess with the time and dates that are displayed in the list (e.g. our keeps defaulting to US when we are in Australia). I personally like to do this as I think it's missed often when new sites are set up.
2. You need to use the Convert time zone action as this will help you to ensure that the list dates/times will be converted correctly to the timezone you want.
Here's an example of mine. I use the SharePoint dynamic content date field to provide the base time, and then set the source to UTC, and destination to your desired timezone. Configure the Format of your date as needed.
Here's a bit more info on this:
https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/
For your second question, I just add a minute from the start date as my end date so it gets onto the calendar.
Hope this provides a way forward for you.
If you run into any issues you can't resolve, please do reply and show us the flow (redact sensitive info like URLs) so that we can help you.
Cheers and best wishes
Damien
Hi Bernd Kroon
Based on your description, here's a few things to consider:
Your first question
1. Make sure that the SharePoint site regional settings are correctly configured as it can mess with the time and dates that are displayed in the list (e.g. our keeps defaulting to US when we are in Australia). I personally like to do this as I think it's missed often when new sites are set up.
2. You need to use the Convert time zone action as this will help you to ensure that the list dates/times will be converted correctly to the timezone you want.
Here's an example of mine. I use the SharePoint dynamic content date field to provide the base time, and then set the source to UTC, and destination to your desired timezone. Configure the Format of your date as needed.
Here's a bit more info on this:
https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/
For your second question, I just add a minute from the start date as my end date so it gets onto the calendar.
Hope this provides a way forward for you.
If you run into any issues you can't resolve, please do reply and show us the flow (redact sensitive info like URLs) so that we can help you.
Cheers and best wishes
Damien
