Hi,
I have created an app for adding diary entries where the date in input by a date picker. It then goes to flow and created the diary entry in google calendars.
For some reason the date flow is provided is always the day before the selected date. I have had a look at other threads about turning the format to Text but this hasn't worked.
Has anyone come across this before?
Solved! Go to Solution.
Hi @Barber_Chris ,
Could you please share a bit more about your scenario?
Do you pass the DatePicker selected date from your canvas app to a Power Automate flow?
If you pass the DatePicker selected date from your canvas app to a Power Automate flow, I think your issue is related here. When working data time values in Power Automate flow, it would be converted into UTC format automatically.
So when you passed a Selected date value from your canvas app to your flow, you would receive the UTC format of the selected date value in your flow. If you still want to get the selected date value from your canvas app in your flow, I think the "Convert time zone" action could achieve your needs.
I have made a test on my side, please consider take a try with the following workaround:
Within the "Create an event" action of Google Calendar connector, set the Start time field to following expression:
formatDateTime(body('Convert_time_zone'), 'yyyy-MM-ddTHH:mm:ss.fffZ')
set the End time field to following expression:
formatDateTime(addDays(body('Convert_time_zone'),2), 'yyyy-MM-ddTHH:mm:ss.fffZ')
Please consider take a try with above solution, check if the issue is solved.
Best regards,
Hi @Barber_Chris ,
I would suggest you check on a few things:
See this below article explaining in details for date differences:
https://www.inogic.com/blog/2019/06/useful-tip-for-the-local-and-utc-setting-in-powerapps/
I hope this resolved your issue if you see any challenge let me know I am always happy to help.
Regards,
Krishna
If this post helps, then please consider Accept it as the solution and give thumbs-up to help the other members find it more.
Proud to be a Super User!
Regards,Hi @Barber_Chris ,
Could you please share a bit more about your scenario?
Do you pass the DatePicker selected date from your canvas app to a Power Automate flow?
If you pass the DatePicker selected date from your canvas app to a Power Automate flow, I think your issue is related here. When working data time values in Power Automate flow, it would be converted into UTC format automatically.
So when you passed a Selected date value from your canvas app to your flow, you would receive the UTC format of the selected date value in your flow. If you still want to get the selected date value from your canvas app in your flow, I think the "Convert time zone" action could achieve your needs.
I have made a test on my side, please consider take a try with the following workaround:
Within the "Create an event" action of Google Calendar connector, set the Start time field to following expression:
formatDateTime(body('Convert_time_zone'), 'yyyy-MM-ddTHH:mm:ss.fffZ')
set the End time field to following expression:
formatDateTime(addDays(body('Convert_time_zone'),2), 'yyyy-MM-ddTHH:mm:ss.fffZ')
Please consider take a try with above solution, check if the issue is solved.
Best regards,
User | Count |
---|---|
203 | |
92 | |
83 | |
47 | |
42 |
User | Count |
---|---|
252 | |
105 | |
103 | |
62 | |
57 |