web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

Power Apps

Suggested Answer

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No

Join the conversation