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
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/
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
31 | |
27 | |
27 | |
21 | |
10 |