Answered

Can't get remove function to work with global variable

(0) Share

Report

Posted on by Grisdale

Greetings everyone,

I have been writing an app that for the sake of simplicity defines a global variable as one of a number of possible tables.

it works fine in galleries and forms however when I attempt to use it in the remove function I get an error saying "the first argument of 'Remove' should be a collection"

my code is as follows

Remove(AFTable, Dropdown1.Selected);
Back()

is there any way to get this to work in a way that won't require me to change the code whenever a new option for AFTable is created?

Categories:

Building Power Apps

All responses (6)

Answers (4)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Grisdale ,

As the error message saying, Remove function only accept collection or actual table as its first argument. So, please try and use ClearCollect instead of Set to create 'AFTable'.

Best regards,
Grisdale 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you explain in more detail please. I am rather inexperienced with power apps.
from what I understand ClearCollect clears a collection completely that adds what you define in the function.

Specifically how would I go about using ClearCollect to define a collection variable?
Verified answer

developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

@Grisdale

As jefferni suggested you need to use collection clearcollect

but if you still want to use the set variable probably you can let us know what is the output of AFTable and what you want to achieve by using Remove(AFTable, Dropdown1.Selected); from that we could provide if there is another possible way.

Please click Accept as solution and Thumbs Up. 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.
Grisdale 12 on at

Like
a
(0)

Report
Copy link

Link copied!

I feel like I am missing some key information here. can you provide a code example of how ClearCollect can be used to define AFTable?

for clarity the table is being pulled from a datasource not created inside of the app itself.
Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@Grisdale

ClearCollect(AfTable, YourSourceData )
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Grisdale ,

You just need to replace Set with ClearCollect in your App for all the Set(AFTable, ...) related formulas. The difference between collections and variables is that variables could only be set or update, in short it's blank value exchanges with a specific value (text, record or table, no restriction), but you cannot modify a variable by adding/removing an item to/in it. While a Collection is a temporary table, you can add a new record to it using Collect, remove a specific record from it using Remove/RemoveIf, update it from beginning using ClearCollect, clear it using Clear, or update a specific record using Patch/Update.

Understand variables in canvas apps - Power Apps | Microsoft Learn

Create and update a collection in a canvas app (contains video) - Power Apps | Microsoft Learn

Best regards,