Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Formula to filter a gallery via button

Dear all


I have somehow built a functioning timesheet with a lot of help from this community, but in my design, I didn't think about scrolling through the gallery as the year progressed. The gallery list is made up of the working days of the year.


So I have added in a menu screen with buttons (see e.g.1) and I'm looking for some help to write a formula which will filter my gallery from a button, so the gallery shows only the days of the month you select. 


My gallery has the following fields (see e.g.2):

  • Body1 = A unique number used to order the list of working days = ThisItem.ID
  • Title2 = A text description of the day/date using three column = ThisItem.Day & " " & ThisItem.Date & " " & ThisItem.Month
  • Subtitle2 = A formula summing the number of hours logged for that day = Text(Value(Hours_1)+Value(Hours_2)+Value(Hours_3)+Value(Hours_4)+Value(Hours_5)+Value(Hours_6)+Value(Hours_7)+Value(Hours_8)) & " " & "hours logged"


How can I write a formula, so that when a button is pressed it filters the gallery to just show entries for a single month?


Logically I would want to write something in OnSelect like: 


Filter based on a unique number





Filter based on unique text



But I have no idea how to express this in PowerApps... Any ideas what I need to write?


Thanks in advance..


Community Support Team
Community Support Team

Re: Formula to filter a gallery via button

Helpful resources


Watch Sessions On Demand!

Continue your learning in our online communities.


PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round


Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!


Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 18 members 4,259 guests
Please welcome our newest community members: