Im trying to sort a gallery based on multiple separate items. Date picker, Search Bar, and Dropdown.
Dropdown has been tricky, values in SP list are "FYI, In Progress, Complete" and i need to add an "All" option that shows everything. Column name in SP for this is "Action Required"
The dropdown works for FYI, In Progress, & Complete, but "All" wont work
Date picker will filter items by SP column "Response Date"
On top of this i would always like the results to be shown by descending date
Gallery Items Property is: SortByColumns(Filter([@'Duty Response'],'Action Required'.Value = Dropdown3.Selected.Value, StartsWith('Guest Name', TextSearchBox1_2.Text)), "Date", Descending)
Dropdown list items: ["FYI", "In Progress", "Complete", "All"]
Any help would be greatly appreciated
Solved! Go to Solution.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!