cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nkilgor
Frequent Visitor

Filter Gallery by Date from Sharepoint List, and Search by Lookup field

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))

 

i.e. 

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.

 

Thank you,

Nate K

12 REPLIES 12

Hi @Nkilgor,

 

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.

31.PNG

Adding the function reference:

StartsWith function in PowerApps

Regards

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks, it does not create any syntax errors, but it does not return any results when searching.

Nkilgor
Frequent Visitor

I was finally able to get it working after the update

 

Sort(Sort(Filter(Trackanooga, IsToday(Date)), Coach.Value, Ascending), Manager.Value, Ascending)

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,942)