Filter excel by unique column and create new file

(0) Share

Report

Posted on by Vickymartigarro

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!!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Vickymartigarro 14 on at

Like (0)

Report
Copy link

Link copied!

Hi @DamoBird365 , could you maybe help me with this?
Thank you!!

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Vickymartigarro

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

Was this reply helpful? Yes No
Vickymartigarro 14 on at

Like (0)

Report
Copy link

Link copied!

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!!

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Vickymartigarro

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

Was this reply helpful? Yes No
Vickymartigarro 14 on at

Like (0)

Report
Copy link

Link copied!

@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"

Was this reply helpful? Yes No