Unanswered

Setting a date variable

(0) Share

Report

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report

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.

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

Like (0)

Report

Thank you! That worked!

Was this reply helpful? Yes No