cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dsantibane
New Member

EXCEL TO SHAREPOINT insert ONLY FIRST ROW.

Hi everyone,i'm new in  powerautomate. I was trying to build a basic app with powerapps that retrieve data from an very old system from acces db i exported this data with ssis to excel (only new rows) then to onedrive. So i try to create this flow.(I have to filter cuz the excel retrive me  blanks rows)

 

dsantibane_0-1606928805909.png

 

But when it run only add the first row (1 of 3 ) and this one have the wrong dates.

 

 

dsantibane_1-1606929151434.png

 

I format the dates this way 

formatDateTime(items('Aplicar_a_cada_uno_2')['Ingreso'],'yyyy-MM-ddTHH:mm:ssZ')
 
Thanks in advance.
 
 

 

 

 

2 REPLIES 2
Paulie78
Super User
Super User

The dates in Excel do not come through as dates. If you look at the output from the Excel get rows action you will see that your dates are not dates at all, but integers:

https://www.tachytelic.net/2020/11/convert-excel-dates-power-automate/

 

Hi @Paulie78  thanks for aswering, but in each output the date is  text.

 

dsantibane_0-1606996336800.png

 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,429)