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.
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.
Look out for new contribution recognition badges coming SOON!
Join us for the first ever Power Platform Online Conference!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!