Forum Discussion

Bernd Kroon's avatar
Bernd Kroon
Brass Contributor
Jun 02, 2020
Solved

Power Automate generates agenda entry at wrong time

I made a Power Automate  that is triggered when a new item in a Sharepoint list is made. Next step is to make an agenda event (V4). Some dynamic data from the list are used to make the event in the A...
  • Damien_Rosario's avatar
    Jun 03, 2020

    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

Resources