News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Filtering form/app on ...

Power Apps - Building Power Apps

Unanswered

Filtering form/app on the landing page by category

(1) Share

Report

Report

Posted on by Brian-Cash

66

Hi all,

I'm building a simple app to collect form submissions to make up a library of results.

These results as captured in a simple SP list.

On the landing/gallery page, by default, it will list the submissions as they come in.

I could like to group all the submissions by a field ('city') so that on the main landing page there would be a list of all

cities and ideally the number of entroes for each

e.g.

London (16) >

Belfast (3) >

Berlin (23) >

How do you get the count of entries per city on the landing page along with the ability to filter by city.

I'm hoping when someone clicks on 'London' it will direct them to a list of 16 aplicable entries.

Any ideas?

Kind regards,

Brian

Categories:

Using Apps Using Formulas

General Questions

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Michael E. Gernaey 41,020 Super User 2025 Season 1 on at

Like (0)

Report
Filtering form/app on the landing page by category

Hi,

Terribly sorry I am running to bed, but wanted to give you a direction

1. You want to use the GroupBy Function to group them by the City

2. Then you have a couple options.

a) use an Add Column and use the CountRows() function to add that column with the Count of the City

b) Or, change the Label Text to be like this (I am assuming its a label)

ThisItem.City & "(" & Text(CountRows(Filter(MySource, City = ThisItem.City))) & ")"

Its late and I may or may not have added too many ) lol but thats the gyst.