cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
t1agow
Helper I
Helper I

Grouping many itens (more than 2k itens)

Hello everyone

 

How can I show, for example, all the brazilian cities in one list?

 

There are more than 5000

I tried group by state, but it doesn't work because it is too big

 

I want something like this
If o choose RJ (state)-> there will be List with all cities in Rio de Janeiro (500 itens +-)

If o choose SP (state) -> there will be List with all cities in Sao Paulo (600 itens +-)

...

PAPP forum.png

Like this image (It is wrong because it haven't all cities)

 

Can someone help me?

Thank you in advance

1 ACCEPTED SOLUTION

Accepted Solutions
PaulD1
Super User
Super User

How about using a combo box, so as you type the city name, Power Apps communicates with the data source and only returns those that match? Scrolling through 500+ items is not a lot of fun, so a Search based approach would likely be better for users.

Alternately (given that cities don't change often), include a 'hard coded' list of cities as a collection in App On Start. If the cities change, you will need to change the list in your App and republish it.

View solution in original post

3 REPLIES 3
PaulD1
Super User
Super User

How about using a combo box, so as you type the city name, Power Apps communicates with the data source and only returns those that match? Scrolling through 500+ items is not a lot of fun, so a Search based approach would likely be better for users.

Alternately (given that cities don't change often), include a 'hard coded' list of cities as a collection in App On Start. If the cities change, you will need to change the list in your App and republish it.

View solution in original post

Hey @PaulD1 

 

That's it. I want to search the city, don't need to show everything.

Could you give me an example? I don't know how to show just the searchbox without a list. I'm begginer on PowerApps, sorry

 

Thank you for answering

I tested other ways and It works, Thank you

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

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.

Users online (1,327)