Answered

Power Apps - Filter then Search

Like (0) Share

Report

Posted on 8 May 2024 16:27:43 by DM-20081516-0

I have a List that shows an Item Title, the Department it applies to, and an "Added" date field. (couple of other fields, but they display based on these three).

We don't want items that are older than 14 days to show.

We have a TextSearchBox that uses Search in the Gallery to be able to type in words, letters, partial strings, etc. and see the related item (for example, they type in "Youth" and they see the title "Youth Mental Health"; or they type in Health Services and see all items related to the Health Services department.

I've been scouring the web and these forums, but can't seem to find the right code to implement the filter first, then the search function. Do I need to try to implement the date range filter in the On Visible control for the screen, and then the Search in the Gallery? Or is there some way to implement a Filter('data source',Today()-14,Search('data source', Title, Deparment)?

Thanks.

All responses (3)

Answers (1)

DM-20081516-0 17 on 08 May 2024 at 19:35:12

Like (0)

Report

Re: Power Apps - Filter then Search

Thank you, Imri-Ami Khan! Worked perfectly. Made me feel kinda stupid for not figuring that out on my own. 🙂
Verified answer

Ami K 15,665 Super User 2024 Season 1 on 08 May 2024 at 19:00:20

Like (1)

Report
Re: Power Apps - Filter then Search

@Mercer - see the pattern below:

Search( Filter( 'Your Data', 'Your Added Date Field' >= Today() - 14 ), TextSearchBox.Text, Column1, Column2, Column3 )

Note that the Search function is not delegable, and neither is it delegable to use "Today() - 14"
DM-20081516-0 17 on 08 May 2024 at 18:40:29

Like (0)

Report

Re: Power Apps - Filter then Search

Actually, it occurs to me that I could/should use the Created field rather than a new column that does basically the same thing....