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

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
iainshaw
Level: Powered On

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
iainshaw
Level: Powered On

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.

iainshaw
Level: Powered On

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
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 (4,721)