cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fabianfadeyi
Regular Visitor

Excel Date not being picked up in flow

Hi Everyone,

 

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. Excel date value.PNG

Any help would be deeply appreciated

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User III
Super User III

Hi @fabianfadeyi 

 

You need to add this as expression. Currently you have added this as a text.

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

10 REPLIES 10
abm
Super User III
Super User III

Hi @fabianfadeyi 

 

You need to add this as expression. Currently you have added this as a text.

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

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.

 

Capture.PNGFlow Checker.PNG

Try the following:

 

formatDateTime(addDays('1899-12-30',int(outputs('Compose_(Start Date)')),'yyyy-MM-dd')),'yyyy-MM-dd')



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Unfortunately, I still get the same issue.

Invalid expression.PNG

 

Try the following:

 

addDays('1899-12-30',int(outputs('Compose_3')),'yyyy-MM-dd')
 
Make sure you are using the correct output compose name.
 
 


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

It's still not liking the value start date in expression

 

addDays('1899-12-30',int(outputs('Start Date')),'yyyy-MM-dd')

 

Capture.PNG

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.

addDays('1899-12-30',int(outputs('body('Get_a_row')?['Start Date']')),'yyyy-MM-dd')

Hi @fabianfadeyi 

 

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.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Still no luck

 

GG.PNGExcel.PNG

I can see there is a space between start date so try start_date



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Capture.PNG

Still the same thing unfortunately

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (24,266)