Answered

Setting a date variable

Like (0) Share

Report

Posted on 2 Dec 2021 20:25:25 by Community Power Pla...

Hi,

I am working on a flow that creates and updates planner task details with a list of information. One piece of information is a date. I initialized the variable as a string and set the variable. See attached. When I update the task details, I use the FormatDateTime expression and use the variable. formatDateTime(variables('xlsxHireDate'),'yyyy-MM-dd') When I test the flow, it fails.

Additional details: I use scope control to combine my steps for error handling. It appears I cannot initiate a variable within a scope.

Thanks for the help!
Initialize variableSet variableExpression Error Error

All responses (2)

Answers (1)

Community Power Pla... on 03 Dec 2021 at 01:30:33

Like (0)

Report

Re: Setting a date variable

Thank you! That worked!
Verified answer

Ellis Karim 10,923 Super User 2025 Season 1 on 02 Dec 2021 at 23:34:42

Like (1)

Report

Re: Setting a date variable

When reading the Excel file, please set the DateTime Format to ISO 8601
Excel stores the date as integers, in a string. Selecting ISO 8601 should convert the data to a date type.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.