Answered

Excel Dates turned to Integers then put into SharePoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

My flow is on a recurring basis. First I am listing rows present in a table with Excel Business Online.

My flow is running successfully, but all of the dates in SharePoint Calendar List are one day too many. For example: The date is supposed to be 1/13/20 and it is being brought in as 1/14/20.

I am using the following expression for the Start and End Times: addDays('1900-01-01',int(items('Apply_to_each_2')?['Start Date']))

I tried to change it to 1900-01-00 as the start date, but Flow will not accept that.

Wondering if there are any other work around options.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

Use this expression instead
convertToUtc()
Here is an example from one of my flows, my local time is MST, and I am using a variable to store the date. So my expression will look like:

convertToUtc(variables('varTaskDueDate'),'Mountain Standard Time')

I hope this helps.

Thanks,
-Josh

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please try to replace 1900-01-01 to 1899-12-30.

Best Regards,

Was this reply helpful? Yes No