Answered

Struggling with Excel Filter Function in Power Apps

(1) Share

Report

Posted on by Johnnywhite

Hi everyone,

I'm currently facing a perplexing issue while trying to utilize the Excel filter function within Power Apps. Despite my efforts to override the 2K row limitation by applying the filter function, it appears that the filter isn't functioning as expected. Here's the formula I'm using:

Sort(Filter(colEvents,StartsWith('Activity Unique ID',txtModule.Value)),'Activity Unique ID',SortOrder.Ascending)

This formula is intended to filter data from an Excel table in Sharepoint based on a specific criterion provided by the user in a text box. However, I'm consistently encountering the 2K row limitation, even after implementing the filter function. One potential solution could be leveraging Lambda Functions to optimize the filtering process and potentially overcome this limitation. Any insights or alternative approaches to overcome this limitation would be greatly appreciated.

Thank you in advance for your assistance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hey @Johnnywhite

did u connect the file directly or not? moving it to onedrive and connecting from there often helps in such use cases.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
mrbrooksshawn 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Quick question that might help you: Have you tried making a collection from your data source using either "Collect(colColName, yourdatasource)" or "ClearCollect(colColName, yourdatasource)"?

Was this reply helpful? Yes No
Verified answer

Johnnywhite 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks it works.

Was this reply helpful? Yes No