Flow brings a date earlier to the one selected in SP list

(0) Share

Report

Posted on by sutekh

509

Afternoon

I have a holiday approval flow running. It fires when a user selects a date in a SP list. The approval works fine but when the data comes through the day before is showing, so when an Outlook event is created it's the wrong date. Is there a regional date setting in Power Automate I can check, or has anyone encountered this before?

Thanks in advance.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@darrenfloyd666

Two things-

1. SharePoint site regional settings.

2. Flow uses UTC time zone. it is advised that use convert time zone action or function in expression.

Thanks

Hardesh

Was this reply helpful? Yes No
sutekh 509 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Hardesh15

The SP site is set to London UTC as is Outlook, so I'm a little confused as to what and how I convert the dates to. I've configured the action as below but I'm not sure of it.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@darrenfloyd666

Select Source time : Coordinated Universal Time

Then check if it solves your problem.

Thanks

Hardesh

Was this reply helpful? Yes No
sutekh 509 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Hardesh15 I'll try it out and check back in

Was this reply helpful? Yes No
sutekh 509 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15

I'm getting the following error: Unable to process template language expressions for action 'Convert_time_zone_2' at line '1' and column '35910': 'The template language function 'converttimezone' expects its fourth parameter to be a string that contains a date time format. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#ConvertTimeZone for usage details.'.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@darrenfloyd666

You Can also use Convert time zone action instead of expression.

please Share your convert time zone expression. Correct way to use it in expression-

convertTimeZone(utcnow(),'UTC','India Standard Time','dd/MM/yyyy')

Thanks

Hardesh

Was this reply helpful? Yes No