Answered

Power Apps - Filter then Search

(0) Share

Report

Posted on 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

DM-20081516-0 17 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@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"

Was this reply helpful? Yes No
DM-20081516-0 17 on at

Like (0)

Report

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

Was this reply helpful? Yes No