You’re offline. This is a read only version of the page.
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.
Thank you, Imri-Ami Khan! Worked perfectly. Made me feel kinda stupid for not figuring that out on my own. 🙂
@Mercer - see the pattern below:
Share
Report
All responses (
Answers (
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"
Actually, it occurs to me that I could/should use the Created field rather than a new column that does basically the same thing....
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
