Filter a column within a SP List

(0) Share

Report

Posted on by AdamH

580

Hi All,

I've been following one of Shane Young's video's on making a calendar in PA

Trying to shape it to my needs a little, I want the filter to only fetch results if a certain choice is used within a set column

So as an example, my SP list is called Staff Secondments, the column I want the formula to filter is called 'Seconded Line' and I only want the filter to display any record with 'Training Line'

ClearCollect(
 colsecondevents,
 Filter(
 'Staff Secondments',
 ('Seconded Start' > varseconsfirstdayview And 'Seconded Start' <= varsecondnextmonth) Or ('Secondment Finish' > varseconsfirstdayview And 'Secondment Finish' <= varsecondnextmonth) Or ('Seconded Start' <= varseconsfirstdayview And 'Secondment Finish' > varsecondnextmonth
 )
));

Any Advice?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,308 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AdamH ,

Probably something like this will do it

ClearCollect( colsecondevents, Filter( 'Staff Secondments', ( ('Seconded Start' > varseconsfirstdayview And 'Seconded Start' <= varsecondnextmonth) || ('Secondment Finish' > varseconsfirstdayview And 'Secondment Finish' <= varsecondnextmonth) || ('Seconded Start' <= varseconsfirstdayview And 'Secondment Finish' > varsecondnextmonth) ) && 'Seconded Line" = "Training Line" ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
AdamH 580 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Thanks for that - I had to modify your example a little as the data type was choice - So i used 'Seconded Line'.Value = "Training Line"

Thanks again Warren!

Was this reply helpful? Yes No