cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trishmalloy
Level: Powered On

Filter formula help

Hello,

 

I have a Gallery control that I want to filter a selected client's workouts on a screen.  Here's the way the app works:

 

- Search for client name (Text input), click Search icon which takes user to the next step

- Presented with Gallery 2 list of names, select a name, navigate to next step

- Go to (filter) that client's list of workouts

 

 

Two Data Sources = Client Profile SharePoint List, Client Name from Client Profile is a lookup column on Client Workout SharePoint List

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filter formula help

Hi @trishmalloy ,

 

In screen2, set below formula in the Items property of the gallery:

Filter('Client Profile SharePoint List', StartsWith(Name, TextSearchBox1.Text))

 

In screen3, set below formula in the Items property of the gallery:

Filter('Client Workout SharePoint List', Name.Value=TextSearchBox1.Text)

 

Regards,

Mona

 

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

View solution in original post

5 REPLIES 5
cds
Level 8

Re: Filter formula help

Neat! Thanks for sharing!

PowerAddict
Level 10

Re: Filter formula help

Set the items property of your Client Workout gallery to something like this:
Filter('Client Workout', 'Client Name' = 'Client Profile Gallery'.Selected.Client Name)

Let me know if this doesn't work.
Community Support Team
Community Support Team

Re: Filter formula help

Hi @trishmalloy ,

 

In screen2, set below formula in the Items property of the gallery:

Filter('Client Profile SharePoint List', StartsWith(Name, TextSearchBox1.Text))

 

In screen3, set below formula in the Items property of the gallery:

Filter('Client Workout SharePoint List', Name.Value=TextSearchBox1.Text)

 

Regards,

Mona

 

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

View solution in original post

trishmalloy
Level: Powered On

Re: Filter formula help

@v-monli-msft - Thank you so much!  I think this is going to work out well!  I really appreciate the help creating this app. 

Highlighted
trishmalloy
Level: Powered On

Re: Filter formula help

@v-monli-msft - This didn't end up working.  I think this would require the trainer to type in the full person's name in the search box for that person's workouts to show up.  They definitely won't want to do this.  Can you give me another idea?

 

 

1.PNG2.PNG

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,323)