SOLVED

Power Automate generates agenda entry at wrong time

%3CLINGO-SUB%20id%3D%22lingo-sub-1433247%22%20slang%3D%22en-US%22%3EPower%20Automate%20generates%20agenda%20entry%20at%20wrong%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433247%22%20slang%3D%22en-US%22%3E%3CP%3EI%20made%20a%20Power%20Automate%20%26nbsp%3Bthat%20is%20triggered%20when%20a%20new%20item%20in%20a%20Sharepoint%20list%20is%20made.%20Next%20step%20is%20to%20make%20an%20agenda%20event%20(V4).%20Some%20dynamic%20data%20from%20the%20list%20are%20used%20to%20make%20the%20event%20in%20the%20Agenda.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVery%20important%20is%20that%20the%20agenda%20event%20is%20scheduled%20at%20a%20date%2Ftime%20which%20is%20derived%20from%20a%20date%2Ftime%20filed%20from%20the%20list.%20This%20is%20where%20the%20flow%20goes%20wrong%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20the%20list%20item%20that%20triggers%20the%20flow%20has%20a%20date%2Ftime%20field%2C%20named%20ReminderTime%2C%20set%20at%2014%3A30%20(which%20is%20a%20time%20some%20hours%20ahead%20of%20when%20the%20listigen%20was%20created).%3C%2FP%3E%3CP%3E-%20I%20used%20that%20ReminderTime%20field%20to%20set%20the%20event%20time%20in%20my%20agenda%20(thus%2C%20at%20at%2014%3A30)%3C%2FP%3E%3CP%3E-%20however%2C%20the%20event%20was%20%26nbsp%3Bcreated%20at%2023%3A30%20in%20the%20agenda.%20Strange!%26nbsp%3BMy%20time%20zone%20is%20UTC%2B1%20(Amsterdam).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20question%3A%20how%20to%20configure%20the%20event%20action%20so%20that%20the%20scheduled%20time%20in%20the%20agenda%20is%20set%20at%20the%20desired%20date%2Ftime%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecond%20question%3A%20what%20formula%20should%20I%20use%20to%20the%20end%20time%20of%20the%20event%2C%20e.g.%2015%20minutes%20after%20the%20start%20time%3F%20In%20the%20flow%20that%20I%20made%20I%20used%20the%20same%20date%2Ftime%20to%20set%20both%20the%20start%20and%20endtime%20of%20the%20agenda%20entry.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20helping%20me%20out%20on%20this%20one!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1433247%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1435434%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20generates%20agenda%20entry%20at%20wrong%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435434%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156612%22%20target%3D%22_blank%22%3E%40Bernd%20Kroon%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20on%20your%20description%2C%20here's%20a%20few%20things%20to%20consider%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EYour%20first%20question%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E1.%20Make%20sure%20that%20the%20SharePoint%20site%20regional%20settings%20are%20correctly%20configured%20as%20it%20can%20mess%20with%20the%20time%20and%20dates%20that%20are%20displayed%20in%20the%20list%20(e.g.%20our%20keeps%20defaulting%20to%20US%20when%20we%20are%20in%20Australia).%20I%20personally%20like%20to%20do%20this%20as%20I%20think%20it's%20missed%20often%20when%20new%20sites%20are%20set%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20You%20need%20to%20use%20the%20%3CSTRONG%3EConvert%20time%20zone%3C%2FSTRONG%3E%20action%20as%20this%20will%20help%20you%20to%20ensure%20that%20the%20list%20dates%2Ftimes%20will%20be%20converted%20correctly%20to%20the%20timezone%20you%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22capture20200603174238255.png%22%20style%3D%22width%3A%20612px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F196115i4B558056B3CE63A8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22capture20200603174238255.png%22%20alt%3D%22Here's%20an%20example%20of%20mine.%20I%20use%20the%20SharePoint%20dynamic%20content%20date%20field%20to%20provide%20the%20base%20time%2C%20and%20then%20set%20the%20source%20to%20UTC%2C%20and%20destination%20to%20your%20desired%20timezone.%20Configure%20the%20Format%20of%20your%20date%20as%20needed.%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EHere's%20an%20example%20of%20mine.%20I%20use%20the%20SharePoint%20dynamic%20content%20date%20field%20to%20provide%20the%20base%20time%2C%20and%20then%20set%20the%20source%20to%20UTC%2C%20and%20destination%20to%20your%20desired%20timezone.%20Configure%20the%20Format%20of%20your%20date%20as%20needed.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20bit%20more%20info%20on%20this%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fworking-with-dates-and-times%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fworking-with-dates-and-times%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20your%20second%20question%2C%20I%20just%20add%20a%20minute%20from%20the%20start%20date%20as%20my%20end%20date%20so%20it%20gets%20onto%20the%20calendar.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22capture20200603174812379.png%22%20style%3D%22width%3A%20607px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F196116i02E8BDC7B91F455D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22capture20200603174812379.png%22%20alt%3D%22capture20200603174812379.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20provides%20a%20way%20forward%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20run%20into%20any%20issues%20you%20can't%20resolve%2C%20please%20do%20reply%20and%20show%20us%20the%20flow%20(redact%20sensitive%20info%20like%20URLs)%20so%20that%20we%20can%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20and%20best%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1435658%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20generates%20agenda%20entry%20at%20wrong%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435658%22%20slang%3D%22en-US%22%3EHi%20Damien%2C%20many%20thanks%20-%20I%20had%20the%20regional%20settings%20considered-%20but%20the%20other%20remarks%20yield%20the%20solution!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1438867%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20generates%20agenda%20entry%20at%20wrong%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438867%22%20slang%3D%22en-US%22%3E%3CP%3EGlad%20to%20help%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156612%22%20target%3D%22_blank%22%3E%40Bernd%20Kroon%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20the%20best%20with%20your%20work!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 Agenda.

 

Very important is that the agenda event is scheduled at a date/time which is derived from a date/time filed from the list. This is where the flow goes wrong:

 

- the list item that triggers the flow has a date/time field, named ReminderTime, set at 14:30 (which is a time some hours ahead of when the listigen was created).

- I used that ReminderTime field to set the event time in my agenda (thus, at at 14:30)

- however, the event was  created at 23:30 in the agenda. Strange! My time zone is UTC+1 (Amsterdam).

 

First question: how to configure the event action so that the scheduled time in the agenda is set at the desired date/time?

 

Second question: what formula should I use to the end time of the event, e.g. 15 minutes after the start time? In the flow that I made I used the same date/time to set both the start and endtime of the agenda entry.

 

Thanks in advance for helping me out on this one!

 

3 Replies
best response confirmed by Bernd Kroon (Occasional Contributor)
Solution

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 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. 

 

capture20200603174812379.png

 

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 Damien, many thanks - I had the regional settings considered- but the other remarks yield the solution!

Glad to help @Bernd Kroon

 

All the best with your work!

 

Cheers

Damien