cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Filtering a Gallery based on a Sharepoint List Lookup

HI, I'm relatively new to PowerApps and this forum has been brilliant.

 

I'm struggling to get a Gallery filter to work.  I've searched similar questions and not been able to get those solutions to work.  It may be something to do with Sharepoint Lists.

 

I've got two Sharepoint Lists Projects and Forecast.  Forecast has a Choice Column that is a Lookup of the Title field from the Projects List.  I have two Galleries and I am trying to filter the Forecast Gallery dependent on the Lookup value from Project.

 

I've tried on filtering on both the Project name and the Project ID and I can't get it to work.  The screeen below shows the Unfiltered values coming back.  

 

Screen.PNG

 

The filter should restrict the Gallery to the last item but I just get errors.  This is the filter I am using.

 

Filter(Forecast, Forecast[@Project]=BrowseGallery1.Selected.Title

 and this is the result on screen.

 

Screen2.PNG

 

Please can someone help.  I am really struggling.  Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

Re: Filtering a Gallery based on a Sharepoint List Lookup

I can't explain why but when I got home and started working on another machine, this formula worked fine.  I'd mark it as solved but I can't see how I do that.

View solution in original post

2 REPLIES 2
Highlighted
Regular Visitor

Re: Filtering a Gallery based on a Sharepoint List Lookup

I'm not quite sure why but this filter started working fine when I tried it again at home on another machine.  Sorry.

Highlighted
Regular Visitor

Re: Filtering a Gallery based on a Sharepoint List Lookup

I can't explain why but when I got home and started working on another machine, this formula worked fine.  I'd mark it as solved but I can't see how I do that.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,059)