You’re offline. This is a read only version of the page.
Announcements
Power Automate Desktop could take Excel as database to connect and filter its data by utilizing SQL.
One of very common task is to split a big sheet (e.g. here Sheet1) into multiple csv files according your conditionals defined in WHERE sentence. Power automate desktop provides very user-friendly interfaces for you to easily build your SQL connection without any coding, then even with simple SQL sentence (10 minutes to learn the basis), you can do a lot.
have a try, interesting, simpler, better, faster.
Hi Tim,
I use this SQL flow to split excel, write to excel file instead of "write to CSV file".Multiple excel file generated without header. Do you know how to copy excel header from original file?
Share
Report
All responses (
Answers (
62
