Share
Report
16Hello,
I am trying to implement a filter on a gallery in a Power App. Specifically, I have a text box that a user would need to enter a string value into and the filter should reduce the records displayed in the gallery to only those that feature a match to the string value entered on a field named “Entry”. Next, I am trying to implement an additional filter where a user can set a start date and end date and also have the gallery filter to display only those records where a table column named “ActivityDateTime” is between the selected start and end date. Lastly, the gallery should always be sorted to display records in descending order (most recent first) based on the “ActivityDateTime” field.
I’ve reviewed several posts in this forum but can seem to find out how to incorporate all filters in one piece of code in the gallery item property.
I have the filter based on the string input in the text field and the sort working but can’t figure out how to add in the date range.
Thank you
SortByColumns(
Search(
Daily_Activities,
FilterEntry_TextBox.Value,
"cr491_entry"
),
"cr491_activitydatetime",
SortOrder.Descending
)
All responses (
Answers (
