cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
fabianfadeyi
Level: Powered On

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
Super User
Super User

Re: Excel Date not being picked up in flow

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!



View solution in original post

10 REPLIES 10
Super User
Super User

Re: Excel Date not being picked up in flow

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!



View solution in original post

fabianfadeyi
Level: Powered On

Re: Excel Date not being picked up in flow

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

Super User
Super User

Re: Excel Date not being picked up in flow

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!



fabianfadeyi
Level: Powered On

Re: Excel Date not being picked up in flow

Unfortunately, I still get the same issue.

Invalid expression.PNG

 

Super User
Super User

Re: Excel Date not being picked up in flow

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!



fabianfadeyi
Level: Powered On

Re: Excel Date not being picked up in flow

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')
Super User
Super User

Re: Excel Date not being picked up in flow

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!



fabianfadeyi
Level: Powered On

Re: Excel Date not being picked up in flow

Still no luck

 

GG.PNGExcel.PNG

Super User
Super User

Re: Excel Date not being picked up in flow

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!



fabianfadeyi
Level: Powered On

Re: Excel Date not being picked up in flow

Capture.PNG

Still the same thing unfortunately

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (6,244)