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

Excel - Insert Rows with Date

Hi,

 

I have table with date column in an Excel file (yyyy-mm-dd).

Using Flow I'm transferring that data from one Excel file (GET ROWS) to another (INSERT ROWS).

 

The result is the date written in the below format.

Any way to get rid of the T:00:00:00Z part?

 

xiXTutL

 

 

 

 

Thanks

 

Ben

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
baldy
Level: Powered On

Re: Excel - Insert Rows with Date

Hi,

 

Thanks for that.

I got what I wanted in the end.

The real problem is that flow always writes data into excel (inserts rows) as text.

And then some systems aren't clever enough to recoginze the value as date (example: Power BI browser version).

But thanks anyways.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Excel - Insert Rows with Date

Hi @baldy,

 

The Date format should be available to control under Excel, once the Date column has been formated, the Date format should be changed automatically when new date data added;

If you would like to format the date input value for Excel Insert-Row, then take use the following method:

Add a Compose Action after the Get Row function, then use the formatDateTime Function to format the date:

Example

"@formatDateTime(body('Get_row')['Date'],'yyyy-MM-dd')"

Formula reference:

Workflow Definition Language

And I think here we can't handle the date outputs format for Insert Row function in Microsoft Flow. That is by defualt.

If you need any further help on this, please feel free to post back.

Regards

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
baldy
Level: Powered On

Re: Excel - Insert Rows with Date

Hi,

 

Thanks for that.

I got what I wanted in the end.

The real problem is that flow always writes data into excel (inserts rows) as text.

And then some systems aren't clever enough to recoginze the value as date (example: Power BI browser version).

But thanks anyways.

View solution in original post

Ponrose
Level: Powered On

Re: Excel - Insert Rows with Date

I too want to insert date in dd/mm/yyyy format in excel sheet by using insert row flow ...but how???

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!

Users online (6,081)