Answered

Lookup column items cached after addition/removal? (Refresh function not a fix)

(0) Share

Report

Posted on by RodM

193

I am working with 2 SharePoint lists within my app (Ex: MainList, LookupList). One of them has a lookup column that relates to the other list.

I also have a form within my app which allows items to be added to the LookupList. However, sometimes after adding items or deleting items, they do not show up, or continue to show even after being deleted. Hard clearing of the browser cache (Ctrl+F5) is the only immediate fix (or whenever the browser cache clears itself via closing/reopening).

I tried Refresh functions in several places, and am not able to get any consistent results. Has anyone run into this before? For additional info, the lookup list has just 265 items.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

HI @RodM ,

Lookup columns are not the best friend of Power Apps at times (I have not used them for many years) and this is another example of their limitations. SharePoint is not a relational database and will not resolve this query automatically without being re-queried. Look up the second list directly and the issue will resolve.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
RodM 193 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz , Thanks for the reply. Can you please provide some specific steps on how to achieve this within a form?

How can I lookup the second list directly within a form tied to the "MainList'? Assuming the form starts with a default code of:
Choices([@'MainList'].'LookupColumn')

What would I change this to to allow direct lookup, and selection of items on a form to be submitted to the 'MainList'? When I tried the following code (along with updating the Fields option) it populates the dropdown with the items needed, but after submitting the form, the data in the 'LookupColumn' field ends up being blank.

Sort('LookupList',Items)
RodM 193 on at

Like
a
(0)

Report
Copy link

Link copied!

I ended up changing the lookup column in the MainList to a text column, and then added a dropdown control to feed it the Selected Items. But if you can still provide possibly another alternative, it would still be appreciated.
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @RodM ,

Depending on whether you wanted Distinct values - I will use that here - just be aware of Delegation limitations

Sort( Distinct( SecondList.LookedUpField ).Result, Result )

It is also an option to design your data to not need lookup columns, with reference lists if necessary due to Delegation.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps