Filter Gallery using custom field

(0) Share

Report

Posted on by indhaa

Hi,

I have created a Gallery for a SP list. On the Gallery I created a custom field to calculate a value.

I added a slider so that I can Filter the gallery based on this value.

However I'm not able to use this column since it is not a field on the SP list. I tried to filter using the Gallery name and this column but still not able to figure it out. Any help

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @indhaa

The column needs to be in Source data or the collection.

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report

Hi,

So my Gallery name is DetailedView and the column name is OverDueCount. This is the field you helped me with to do the calculation.

This is Not a collection and NOT a SP column .

So I added a Slider and want to filter based on this column. I haven't done a filter like this before based on a custom field on a gallery and my code getting an error.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @indhaa

We need to change the way OverDueCalculated.

Set the Items property of Gallery to (Using Existing code that I sent)
//DeviceOrdering Filter( AddColumns( DeviceOrdering, "OverDueCalculated", With( { DateRange: ForAll( If( ThisRecord.DueDate > Today(), Sequence( ThisRecord.DueDate - Today(), 0 ), Sequence( Today() - ThisRecord.DueDate, 0 ) ), Weekday( DateAdd( DueDate, Value ) ) ) }, If( IsBlank(DueDate) || DueDate > Today(), 0, DateDiff( DueDate,/* Start Date */ Today()/* End Date */ ) - CountRows( Filter( colHoliday, HolidayDate >= DueDate, HolidayDate <= Today() ) ) - CountRows( Filter( DateRange, Value = 6 ) ) - CountRows( Filter( DateRange, Value = 7 ) ) ) ) ), OverDueCalculated < Slider1.Value )

in the gallery Set the Text property of OverDue Label control to
ThisItem.OverDueCalculated

Note: Change the SliderName (Slider1)

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Hi Stalin,

Thanks for your help

I need a little help. Already I have other filtering in the gallery. When I try to amend it with the overdue code you provided I'm getting an error. With only the Overdue filter it is working but when I try to combine I'm having a issue. Below is the code I'm trying to combine
SortByColumns( Filter( DeviceOrdering, StartsWith(RequestTitle, TitleFilterInput.Text) && RequesterDepartment = RequesterDeptFilterInput.Selected.Result && Priority.Value = PriorityFilterInput.Selected.Value ), "ID", Descending)

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Hi @indhaa

With( { _item: AddColumns( DeviceOrdering, "OverDueCalculated", With( { DateRange: ForAll( If( ThisRecord.DueDate > Today(), Sequence( ThisRecord.DueDate - Today(), 0 ), Sequence( Today() - ThisRecord.DueDate, 0 ) ), Weekday( DateAdd( DueDate, Value ) ) ) }, If( IsBlank(DueDate) || DueDate > Today(), 0, DateDiff( DueDate,/* Start Date */ Today()/* End Date */ ) - CountRows( Filter( colHoliday, HolidayDate >= DueDate, HolidayDate <= Today() ) ) - CountRows( Filter( DateRange, Value = 6 ) ) - CountRows( Filter( DateRange, Value = 7 ) ) ) ) ) }, SortByColumns( Filter( _item, OverDueCalculated < Slider1.Value && StartsWith( Title, TitleFilterInput.Text) && RequesterDepartment = RequesterDeptFilterInput.Selected.Result && Priority.Value = PriorityFilterInput.Selected.Value ), "ID", Descending ) )

I assumed other filter already working
&& StartsWith(Title,TitleFilterInput.Text) &&
RequesterDepartment = RequesterDeptFilterInput.Selected.Result &&
Priority.Value = PriorityFilterInput.Selected.Value

Was this reply helpful? Yes No