cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tChmiel
Frequent Visitor

How to Filter Large Excel Data to work within Powerapps limit of 500 rows

I have a pretty large spreadsheet (18000 rows) that get updated once a month.

It has only 4 columns:  Product, Region, SubRegion, SalesPerson.

 

Product is a fixed list.  (<100)

Region is a fixed list (<25)

SubRegion is dependent on Region.  (<100 for a given region)

     Subregions could be states based on Region "US", or subregions could be countries based on Region "Europe".

Subregions will be fixed for each region.

SalesPerson is just a user who could be a lookup to a Office 365 user.

 

SalesPerson column is the column that could change per month, rest of the Excel data is constant.

 

Given this setup, can I create a PowerApp which can filter this list by Product and Region, and only display SubRegions and the corresponding SalesPerson? This is a readonly app.  Assuming I can filter on two columns at once( product = "x" and Region = "y"), I can always guarantee that the result will return <100 rows.

 

I can not import the data to Azure, nor can I import to a SQL database, nor access the original source.  Really trying to make this a tool to be managed by an InfoWorker. 

 

Any ideas on how to achieve this within Powerapps?  Is it possible to filter a large Excel file down to a managable set of data?

 

I am really trying to show the power of multiple platform (android, ios, Windows) apps - but frustrated with this 500 row limit.

 

Tom 

1 REPLY 1
hpkeong
Community Champion
Community Champion

Hi

There is a work around solution provided by @Mr.dang.

Please search for his detail explanation on how to achieve this.

Hope this helps
hpkeong

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,783)