Within flow i am using the get row for excel business to retrieve a list of details. One of these items are a start date. The start date is formatted within a UK Format DD/MM/YYYY (if that makes a difference). When retrieving the date i can a value of 5 digits. This seems to be a common issue from what i've been googling however i cannot find a valid solution.
The closest i could find was this forum here - https://powerusers.microsoft.com/t5/Building-Flows/Convert-Excel-date-value/td-p/105686
I have the exact same error as the attached image.
Any help would be deeply appreciated
Solved! Go to Solution.
When putting this as an expression formatDateTime(adddays('12-30-1899',int(outputs('Compose_(Start Date)')),'yyyy-MM-dd'),'yyyy-MM-dd') i then get the following message.
Try the following:
It's still not liking the value start date in expression
I can instead try the following to get the below command but i still get the expression is invalid.
If it helps i can provide the flow template and excel sheet as there is no confidental data and i'm testing ot the function for another flow.
From the screenshot you have focused on the Dynamics Content and trying to update. Try and remove the current mapping. Make sure the focus is on expression tab and past the formula.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!