Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

How to clear an applied filter of online Excel by Power Automate

(1) ShareShare
ReportReport
Posted on by 7

Dear Sir,

 

I am using the Power Automate to querying the tables on online Excel, everything works fine until there is someone goes into that excel and applied the filter, they quit the file without clearing the filter so that it made my flow read the uncompleted data.

My question is, how can we clear all the applied filter on the online Excel before querying by Power Automate.

 

Thanks in advance.

 

Best Regards,

Apisit Phetchakan.

  • Re: How to clear an applied filter of online Excel by Power Automate

    To clear all the filters from your table you can create an Office Script to clear the filters.

    Then you will use the Power Automate flow's connector "Run Script" and execute the filter from the table.

  • oleshy Profile Picture
    oleshy on at
    Re: How to clear an applied filter of online Excel by Power Automate

    When someone applies a filter without clearing it in the Excel Online Editor, this filter is applied for everyone else, including your flow. Therefore you won't be able to read the data which are filtered out by this filter. As indicated in the official documentation (https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/):

    • A single Excel file should be used by a single connection to prevent writing data from multiple connections and possible data inconsistency.
    • Simultaneous file modifications made by other connectors or manual edits are not supported.
  • aphetchakan Profile Picture
    aphetchakan 7 on at
    Re: How to clear an applied filter of online Excel by Power Automate

    Hello Bof, @v-bofeng-msft 

     

    Really appreciated for your reply.

    I have already done this way before but it was not solved my problem.

     

    Pagination.JPG

     

    Thanks,

    Apisit.

  • Re: How to clear an applied filter of online Excel by Power Automate

    Hi @aphetchakan :

    You can get more rows returned by setting a higher value for the pagination settings.

    1. Go to "List rows present in table" action
    2. Select the options elipses ("...")
    3. Select 'Settings'
    4. Enable Pagination
    5. Set an appropriate row limit

    1.png2.png

    Best Regards,

    Bof

  • aphetchakan Profile Picture
    aphetchakan 7 on at
    Re: How to clear an applied filter of online Excel by Power Automate

    Hello @v-bofeng-msft,

     

    Thanks for the replying. The issue will not be happed if the number of record is not too much, probably lesser than a thousand. When the number of row is greater than 1,500, we will be facing an issue of not found the record behind the filtered.

     

    First screenshot I produced the case by not making the filter applied, it is working fine.

    First-ss-filter-applied.JPG

    The second screenshot, I reproduced the case by applied the filter, so I could not find the record as expected.

    Second-ss-filter-applied.JPG

    Thank you,

    Apisit

  • Re: How to clear an applied filter of online Excel by Power Automate

    Hi @aphetchakan :

    Could you tell me what action you used to get rows?

    I've made a test but did not encountered the problem you mentioned:

    1\My excel documents are saved in Onedrive. I first use "Filter" to hide some rows

    1.JPG

    2\My flow

    2.JPG

    3\The Result

    3.JPG

    Although I did not clear the filter rules, I still got all the rows

    Best Regards,

    Bof

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,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics