Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Filter excel by unique column and create new file

(0) ShareShare
ReportReport
Posted on by 14

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.

 

Vickymartigarro_0-1682344874604.png

 

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:
  • Vickymartigarro Profile Picture
    Vickymartigarro 14 on at
    Re: Filter excel by unique column and create new file

    @DamoBird365 
    Yes, i added the extension:

    Vickymartigarro_0-1682358865462.png

     

    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"

    Vickymartigarro_1-1682359156671.png

     

  • DamoBird365 Profile Picture
    DamoBird365 8,942 on at
    Re: Filter excel by unique column and create new file

    @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

  • Vickymartigarro Profile Picture
    Vickymartigarro 14 on at
    Re: Filter excel by unique column and create new file

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

  • DamoBird365 Profile Picture
    DamoBird365 8,942 on at
    Re: Filter excel by unique column and create new file

    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

  • Vickymartigarro Profile Picture
    Vickymartigarro 14 on at
    Re: Filter excel by unique column and create new file

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard