Unanswered

Filtering out selected items from items control in combo box

(0) Share

Report

Posted on by martinav

3,347

Not sure if there is a better way, but it is possible that the items may show an identical item shown in the selected items control in a combo box. How can I filter them out??

This shows circular reference, which makes sense. This is the items control of cmb_SNSelect combo box.:

Filter(WOFilter,!CountIf(cmb_SNSelect.SelectedItems,Value=ThisRecord.Value))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @martinav,

I would've also solved it in that manner. Is the issue that the Filter() does not work? This might be because Power Apps does not know what 'ThisRecord' actually refers to, since we have nested functions that loop through the datasource (countif & filter).

A way to solve this is by explicitly telling what record we are refering to via 'As NameForThisRecord':
Filter( WOFilter As Main, !CountIf( cmb_SNSelect.SelectedItems, Value = Main.Value ) )

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
martinav 3,347 on at

Like (0)

Report
Copy link

Link copied!

Yes, that is smart to be explicit, but yet, it didn't resolve the circular reference problem. I may have to trigger an external context to generate items somewhere else using OnChange. I was hoping not too. It just dirties up the application.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!

My Apologies @martinav, I was wrongfully under the impressions that we wanted to filter based on another combobox selection. I should've read more carefully 🙂

Indeed, referencing the SelectedItems of the same control leads to a circular reference. This problem persists when adding the With() function and locally store the selection as a workaround.

In my previous solutions, I collected the selection during the OnChange and filtered based on the collection items (alternatively use a variable). However, as you said - it leads to yet another external context.

Was this reply helpful? Yes No
martinav 3,347 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM ,

Yea, its all good. No harm done. Its very difficult to keep applications orderly as you know. I have been making some very complex applications, and I'm worried that if/when I get hit by a bus if anyone will be able to decipher them to keep them going.

Was this reply helpful? Yes No