SharePoint additional lookup fields cannot be filtered

[Edwin-Abdalian]

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 myLookup

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"
• Now try to filter the gallery and use Filter(DetailList, 'myLookUp:City'.Value = "Glendale"), and it doesn't find that column

[v-xida-msft]

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,

[Edwin-Abdalian]

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)