Show all using a radio group and filter by current date in Gallery

(0) Share

Report

Posted on by caslasgee

223

Good day,

I have a SharePoint list that contains records. See below.

To avoid delegation, I add a clearcollect to collect the years in the SP list using the following;

ClearCollect(ProjYear,'SharePoint List')

and added a radio button (rby) putting the below code to populate the Year

Distinct(ProjYear,Year(Date1))

Also, I have added a checkbox to filter current records.

And finally, i added a Gallery (gal1) inserting the below code in the Item

Filter(
 'SharePoint List',
 Date1>= Date(
 rby.Selected.Value,
 1,
 1
 ),
 Date1<= Date(
 rby.Selected.Value,
 12,
 31
 )
)

With this, I am able to filter the records by year. Now my question is;

1. I would want to be able to show all the records if no year is selected. (in the radio group).

2. Using the CheckBox, I will like to filter the current records using the Date1 Column (= or greater than today).

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @caslasgee ,

A few things here - A collection does not solve Delegation issues, just masks the problem as it too is subject to your Delegation limit. Rather than leaving a "one-time" collection hanging around, you can do this

With( {wData:'SharePoint List'}, Distinct( wData, Year(Date1) ) )

The second issue is that putting those date calculations inside a filter is not a good idea, so get them out of there and "pre-calculate" them. Combining this with your two requirements, try this

With( { wStart: Date(rby.Selected.Value, 1, 1), wEnd: Date(rby.Selected.Value, 12, 31) }, Filter( 'SharePoint List', ( CheckBox1.Value && Date1 >= Today() ) || ( !CheckBox1.Value && ( Len(rby.Selected.Value) = 0 || ( Date1 >= wStart && Date1 <= wEnd ) ) ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
caslasgee 223 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz, Thanks for the insight on how delegation works.
I ran the code for the filter accordingly, but a portion of it gave the below error.
And when i hover around the highlighted portion, It gave the below message.

Thank you.

Was this reply helpful? Yes No
caslasgee 223 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz, Thanks for the insight on how delegation works.
I ran the code for the filter accordingly, but a portion of it gave the below error.
And when i hover around the highlighted portion, It gave the below message.

Thank you.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@caslasgee ,

Just a typo - needs && (now fixed - I thought you might ave picked that one up)

Was this reply helpful? Yes No