Answered

Flow Converting Date to String in Outlook, How to keep as Date?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am brand new to FLOW and trying to automate a workflow. Basically someone submits a project number that needs to be exteneded, and based on some criteria I either approve/reject that, and send an email to the requestor. SO far I have everything working, except I reference the new dates in the email reponse, and they are coming back formatted as a string.

Example Email (Date/String Highlighted)
2019-08-22 10_57_31-Inbox - Robert.Lau@gartner.com - Outlook.jpg

Flow

2019-08-22 10_59_29-Edit your flow _ Microsoft Flow.jpg

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

check this thread
https://powerusers.microsoft.com/t5/Building-Flows/Date-problem-flow-from-excel-to-sharepoint/td-p/189037

Excel online connector converts date to number (its a limitation)

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please take a try with expression below for the date time from excel online:

addDays('1900-01-01',add(int(datetimefromexcel),-2))

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Sunasara 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Go to your excel file and change format from Date to Text.

Hope this helps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I just ended up adding an additional column and using the "Concat" function with Month, date, and Year embeded into the CONCAT function. Then I linked this new column. It is sad that I have to work around the date like this, but it worked.

Was this reply helpful? Yes No