Answered

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

(0) Share

Report

Posted on by Community Power Pla...

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)

Verified answer

RezaDorrani 12,143 on at

Like (0)

Report

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 on at

Like (0)

Report
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 (0)

Report

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

Hope this helps

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

Like (0)

Report

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