Hi all.
I´m trying to do the following:
I have an excel file stored in sharepoint.
I´m trying to filter excel by unique column and create a new file.
In this example, i wish to have created 3 new excel files (one for each state).
Does someone know how to do this?
Thank you!!
@DamoBird365
Yes, i added the extension:
But when i open the excel this error appears:
Translation in english would be: "Excel cannot open the file "Asoprofarma.xlsx" because the format or the extension are not valid. Check that the file has not been corrupted and that the file extension and format match"
Glad they’ve been of help and you’ve made it this far 👍 what’s the error? Can you share some more detail? Have you included the file extension xlsx when creating the file?
Damien
Thank you @DamoBird365 !! Your video was super!!
I tried changing the html table to creation a new file. I have succesfully been able to creat the files, but when i try to open them, an error pops up and i cant see the information inside.
Has this occured to you before?
Thanks!!
If you have access to Office Scripts, you could check out https://youtu.be/hW47n-StNUc and split your data into new sheets. This could be adapted to return the data of each sheet back to Power Automate and generate new files using either office scripts or graph API - something like https://youtu.be/4g8Lh0gzEnc or https://youtu.be/mNwEk7hLdfE.
Another video, if you are relatively new to Power Automate, check out https://youtu.be/pwJ73jFEtDQ where I convert Excel into unique HTML tables. You could replace the HTML table action with creating a new Excel File from one of the videos above.
Cheers
Damien
Hi @DamoBird365 , could you maybe help me with this?
Thank you!!