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.
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,
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?
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
180 | |
62 | |
32 | |
30 |
User | Count |
---|---|
324 | |
269 | |
104 | |
74 | |
56 |