removing item from collection not working

(1) Share

Report

Posted on by disappointed

The solution to this should be easy but so far I have not been able to find the correct syntax.

Dropdown1 is populated using a collection, colPurposes.

I want Dropdown2 to be the same collection less the item selected in Dropdown1.

Dropdown1 items: colPurposes

Dropdown2 items: Remove(colPurposes,'itemContents'=Dropdown1.Selected.'itemContents')

The remove doesn't work.

I have also tried:

RemoveIf,

putting the selection in Dropdown1 in a variable and trying to compare that in the Remove,

Remove(colPurposes,{Value: Dropdown1.Selected.'itemContents'})

I also added temp text fields to display the value in the Selected item.

Any direction appreciated.

Categories:

Building Power Apps

All responses (6)

Answers (2)

Sort by

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hey @disappointed ,

you can use the Remove function like this:
Remove(colPurposes,Dropdown1.Selected)
Remove and RemoveIf functions - Power Platform | Microsoft Learn

I've never tested it this way so let me know if it works.
disappointed 90 on at

Like
a
(1)

Report
Copy link

Link copied!

Good try but it didn't work. I get the "There is an error in this formula. Try revising and running it again. Data type: Record."
Like I say, it should be simple.
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Then we will do it the old Fashioned way:
Remove(colPurposes,LookUp(colPurposes, ID=Dropdown1.Selected.ID))
This should work. Just make sure where to put the code. It can't be placed as Item in Dropdown 2
disappointed 90 on at

Like
a
(1)

Report
Copy link

Link copied!

I have been trying to put it in items. Dropdown2 is not visible until a selection is made in Dropdown1. What's your recommendation for where it should go?
Verified answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
It has to go in a button or OnChange. However OnChange has the risk to delete a Record that has been selected by accident. To just use the Itsem proprty you could do this:
Filter(colPurposes, ID <>DropDown1.Selected.ID)

Your collection does not lose Data but the dropdown 2 will not show the record selected in Dropdown 1.
Verified answer

disappointed 90 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes!!! This syntax worked. Thank you.
Carter