I have managed to get this to work with my sharepoint list but, this will be used as a daily tracker and the gallery needs only to display items that are for the current day.
SortByColumns(Filter(Tracker, StartsWith("Coach",TextSearchBox1.Text)), "Date", If(SortDescending1, Ascending, Descending))
Date 3/6/2017 - Date value from date picker
Manager Person - selected from lookup of another sharepoint list
Coach Person - selected from lookup of another sharepoint list
Sales Text entry
I need the end user to be able to see only items created "Today" and search for entries that match the Manager coloum.
Solved! Go to Solution.
Please take a try with the following:
Filter(Tracker,IsToday(Date), startswith(AAL.DisplayName, TextSearchBox1.Text))
There would be warnings when using this formula, but you should be able to see the filtered results.
Adding the function reference:
I was finally able to get it working after the update
Sort(Sort(Filter(Trackanooga, IsToday(Date)), Coach.Value, Ascending), Manager.Value, Ascending)
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.
In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.