Unanswered

Solution to SharePoint's Limitation to nested lookup columns in powerapps

Like (0) Share

Report

Posted on 11 Nov 2022 14:32:04 by jimi_hendrix

So call me nuts or what, I had a working PowerApps gallery filtering off of a SharePoint list which had a lookup column from a list and was bringing in an additional lookup column from a 3rd list. Waking up one morning to find the SharePoint list not displaying the lookup column data from the 3rd list..

What are some options to solve this.. I could do a power automate flow to get a single line of text in there and filter off of that.. or maybe i can run a filter for PowerApps. So I'm reaching out for the later

My main question will be around how to filter a gallery from a dynamic qty of conditions.

For example, what I would like to filter on, depending on the value could have 1, 2, 3+ results that Id then need to filter the gallery on. Im not quite sure how to accomplish this. Please advise

Categories:

General Questions

All responses (2)

Answers (0)

TylerPA 201 on 11 Nov 2022 at 15:09:38

Like (0)

Report
Re: Solution to SharePoint's Limitation to nested lookup columns in powerapps

If you are trying to keep this in powerapps: general overview, you would need to collect your 3 lists into separate collections. Then your gallery would have a complex filter

Filter(collection, column in collection2.name, anotherColumn in collection3.description...)

If the lists you are bringing in, are just a single column of choices, you could just plant that directly into powerapps instead. All based on your needs
cha_cha 4,932 Moderator on 11 Nov 2022 at 15:04:30

Like (0)

Report

Re: Solution to SharePoint's Limitation to nested lookup columns in powerapps

Hello jimi_hendrix,

If you are not on a tight budget, Dataverse has the native function that you are looking for.

If on a tight budget and your table is not that big, work on storing the tables in Collection a do the mapping like using ForAll.

If table is quite big, please refer back to Dataverse.