Unanswered

Gallery Lower the Data imported from a list to specific Months

(0) Share

Report

Posted on by jamescosten

643

I have a gallery that filters by 2 drop downs and a search criteria. This works fine however i ran into a problem today with the limit set by the app of 500 entries. I have upped the limit to 1000 but what i would like it to add an additional filter to the one below in the image to only show the current month and the last month. So in this instance only Augusts and Septemebers entries.

Code: If(!IsBlank(TextInput2.Text),Filter('Time Sheets','Tool Number' = TextInput2.Text),Filter('Time Sheets', Employee.Value = Dropdown2.Selected.Value && Month = Dropdown3.Selected.Result))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

BCBuizer 22,752 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @jamescosten ,

Can you please share the data type of the Month column? Assuming it's a choice or text type, it's not so simple to select anything else besides what is selected in the dropdown because it's hard to know what is "next" or "last" since the relationship between the items is not defined.

In an case I advise to simplify your filter a bit:

Filter( 'Time Sheets', IsBlank(TextInput2.Text) || 'Tool number' = TextInput2.Text, Employee.Value = DropDown2.Selected.Value, Month = Dropdown3.Selected.Value )

Was this reply helpful? Yes No
jamescosten 643 on at

Like (0)

Report
Copy link

Link copied!

The month column is: a claculated column from the Creation date column, this is for filtering ease. The problem Im having is that the data set is imported then filtered to the drop down so the actual entries being pulled through is large, but is there a way to only import a selection of data from the list?

Also your code did not work when i just entered it, it would not pull through the data.

Was this reply helpful? Yes No
BCBuizer 22,752 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @jamescosten ,

The delegation issue is caused because you are trying to filter a calculated column:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-a-gallery-with-Calculated-column-in-sharePoint-of-type/m-p/1255441/highlight/true#M329585

Since using the Month() function on a Date column will also cause delegation issues, you may want to pre-filter for 'Tool Number' and Employee and then filter for month:

Filter( Filter( 'Time Sheets', IsBlank(TextInput2.Text) || 'Tool number' = TextInput2.Text, Employee.Value = DropDown2.Selected.Value, ), Month = Dropdown3.Selected.Value )

Was this reply helpful? Yes No