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
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

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

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,595)