EXCEL TO SHAREPOINT insert ONLY FIRST ROW.

[dsantibane]

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)

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

I format the dates this way 

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

Thanks in advance.

[Paulie78]

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/

[dsantibane]

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