Answered

Difference between flow date and sharepoint list

(0) Share

Report

Posted on by LearningPA23

I am getting data from SQL Server and one of the column has Date and Time, when I use that field to update sharepoint List column date and time, same name in column. The times are different.

PA Update Item.png

SharePoint List.png

How can I fix this issue?

Categories:

General topics

I have the same question (0)

All responses (15)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you check if your SharePoint site is in the same timezone?

Change regional settings for a site - Microsoft Support

Was this reply helpful? Yes No
LearningPA23 18 on at

Like (0)

Report
Copy link

Link copied!

Hi SundeepGhataKNZ,

Appreciate your feedback. I did check that and the site is set for the correct time zone (Easter Time Zone). That unfortunately does not fix the problem.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you able to post a screenshot of the Update action in designer mode?

Was this reply helpful? Yes No
LearningPA23 18 on at

Like (0)

Report
Copy link

Link copied!

As you can see the date is fed by the compose above, this is the formula:
if(empty(items('Apply_to_each')?['NextMeetingStartDate']),null,formatDateTime(items('Apply_to_each')?['NextMeetingStartDate'],'MM/dd/yyyy hh:mm tt'))
It comes out well just the time zone is the issue. I had the timezone format in there but that didn't work either, also tried put the "G" and that didn't work.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@LearningPA23 ,

In your Compose action use the UTC format

formatDateTime('Your SQL Date','yyyy-MM-ddThh:mm:ssZ')

Was this reply helpful? Yes No
LearningPA23 18 on at

Like (0)

Report
Copy link

Link copied!

still didn't work, time and zone shows 5:00 AM when it should be 9:00 AM

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
What is the output of your Compose action with the UTC format ON?

formatDateTime('Your SQL Date','yyyy-MM-ddThh:mm:ssZ')

Can you provide the value?

Trying to understand where the problem is, SQL or SP

Was this reply helpful? Yes No
LearningPA23 18 on at

Like (0)

Report
Copy link

Link copied!

Value with your recommended change
Value before format change

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
It is definitely to do with time zone

Can you try this?

convertTimeZone(triggerBody()?['YourDate'],'UTC','Eastern Standard Time','yyyy-MM-dd HH:mm:ss')

Was this reply helpful? Yes No
LearningPA23 18 on at

Like (0)

Report
Copy link

Link copied!

Now I get 1:00 AM as the time. And the null error.

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'convertTimeZone' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#ConvertTimeZone for usage details.'.

Shows 5:00 with no AM/PM but shows 1:00 AM on the sharepoint list

Was this reply helpful? Yes No