cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Solution Supplier
Solution Supplier

SharePoint additional lookup fields cannot be filtered

Does anyone know how to fix this?

I have a simple lookup on my DetailsList, which looks up Patients records on my Patients list. This is how I created myLookupmyLookup.png

 

I can display the extra lookup fields in a gallery. but I cannot filter them. to PowerApps, those columns don't exist during filtering.

  • I can show the City column in my gallery. the logical name of this column in Sharepoint in "myLookUp%5Fx003a%5FCity" galitems.PNG

     

  • Now try to filter the gallery and use Filter(DetailList, 'myLookUp:City'.Value = "Glendale"), and it doesn't find that columngalfilter.png

     

2 REPLIES 2
Community Support
Community Support

Hi @Edwin-Abdalian ,

Based on the issue that you mentioned, I think you have some misunderstanding with additional lookup fields of SP list in PowerApps app.

 

Currently, within PowerApps, the additional lookup fields of SP list could only be displayed as values within an app, it could not be used as a Filter column in PowerApps app.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

As an alternative solution, please consider modify your formula as below:

Filter(
         DetailList,
         myLookUp.Value = LookUp('Patients list', City = "Glendale", ID)
)

Please consider take a try with above solution, check if the issue is solved.

 

Best regards,

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

Your proposed solution won't work in my scenario. The Lookup returns only 1 record, right? I may have 10 patients in Glendale, I need to get the IDs of all and show them in my gallery.

I had some time to go and test this further. I think this is a bug in PowerApps. I used the follwing expressions to filter my items. one of them works, the other doesn't. both use the same SharePoint additional lookup field. 

 

Should I submit this in the ideas page?

 

  1. Filter(Appointments, StartsWith('PatientLookup:First Name'.Value, TextInput1.Text))  This works (however with a delegation warning, which I don't know why, since StartsWith is now delegable on complex fields. but it's not the subject of this discussion) @RezaDorrani , Please cover this in your next SharePoint delegation video
  2. Filter(Appointments, 'PatientLookup:First Name'.Value = TextInput1.Text)  This doesn't work and gives me the error(second picture)

 

1.jpg2.jpg

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (5,975)