Combo Box filter Gallery -> Circular References

(0) Share

Report

Posted on by milky_bar_may

228

Hi everyone!

I have a very annoying issue.

I have a Combo Box sitting outside my gallery. The ComboBox1 items is = "ForAll(Filter(SP List, OrderNumber = Gallery1.AllItems.OrderNumber)),OrderNumber)"

In my Gallery I have the items filtered by:

Filter(SP List, OrderNumber = ComboBox1.Selected.OrderNumber)

It's giving me a circular references error (as well as a headache!)

Any help appreciated.

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (2)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

The Combobox formula is referring to the Gallery and the Gallery is getting the result from the Combobox. Circular reference.

Can you alter the combobox formula
"ForAll(Filter(SP List, OrderNumber = Gallery1.AllItems.OrderNumber)),OrderNumber)"

To: Distinct(SP List, OrderNumber)
Or SP List.OrderNumber
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @milky_bar_may

It looks like you are making this more complicated than it needs to be. I suggest that you make the Items property of the combobox Sort(SP List', OrderNumber ), Descending) and make the Items property of the gallery Filter('SP List', OrderNumber = ComboBox1.Selected.OrderNumber)
milky_bar_may 228 on at

Like
a
(0)

Report
Copy link

Link copied!

Both solutions worked perfectly, thank you.

Some times I feel like the biggest idiot in the room !

Thanks for your help @eka24 and @Drrickryp