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

I have the same question (0)

All responses (6)

Answers (2)

Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (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.

Was this reply helpful? Yes No
disappointed 90 on at

Like (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.

Was this reply helpful? Yes No
Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (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

Was this reply helpful? Yes No
disappointed 90 on at

Like (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?

Was this reply helpful? Yes No
Verified answer

Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (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.

Was this reply helpful? Yes No
Verified answer

disappointed 90 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No