web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Can't see all groups i...
Power Apps
Unanswered

Can't see all groups in filter

(0) ShareShare
ReportReport
Posted on by

Hi, I have a gallery that shows me the items from the excel file. In excel there is a column "Group" which determines the affiliation of the assortment. filters are placed on the gallery:

 

 

With({asmt:Filter(
 asortyment;StartsWith(
 'Nazwa asortymentu';TextInput5.Text
 )
 )
 };
 If(
 filtr.Selected.Result = "Pokazuj wszystko"; asmt;
 Filter(
 asmt;Grupa=filtr.Selected.Result
 )
 )
)

 

 

Filters present on the page onVisible

 

 

ClearCollect(kolekcja_filtr;{Result:"Pokazuj wszystko"});;
Collect(kolekcja_filtr;Distinct(asortyment;Grupa))

 

 

The problem is that in excel I have 7 groups and in powerapps I see only 5

 

powerapps has a limit of 500 records, when i set limit to 1000 I have an error cannot insert a new column to store identifiers

Categories:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard