Hi,
I am trying to load data from an excel file to sqlserver. All other fields are loading perfectly except date column. I am getting an error and have herewith attached the screenshot of it. The date is reading as int, whats the solution for it.
Thanks,
hi @Shivaji this is a common problem with excel, Power Automate convert your date to a number when you use get rows, the only solution I found was convert the data type of excel file see my video
https://www.youtube.com/watch?v=hjkftEtPPCg&t=2s
I invite you to susbribe it too 😉
Proud to be a Flownaut!
Thanks for your reply.
Still my date is loading into database. I have herewith attached the screenshot.
Is the solution presented here of any help?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
64 | |
23 | |
16 | |
15 | |
11 |
User | Count |
---|---|
121 | |
36 | |
32 | |
28 | |
26 |