Remove function -

(0) Share

Report

Posted on by claudia

208

Hello everybody,

1. I have gallery which have as a data source a SharePoint library.

2. I have added a Delete button, outside of the gallery

On select from the Delete button, I have used the following formula:

Remove('Contracts / Agreements to be Approved', galOverview.Selected)

Contracts / Agreements to be Approved = data source - SharePoint library

galOverview = Gallery

Unfortunately I receive the following errors:

Incompatible ID column in the data source you're updating expects a 'Number' type and you're using a 'Control' type.

The function "Remove" has some invalid arguments.

Please can anybody, help me with this issue?

Thank you, for your kind support,

Claudia

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (1)

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report

It expects an ID
Remove('Contracts / Agreements to be Approved', galOverview.Selected.ID)

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (1)

Report
Hi @claudia

Please use below formula if it helps your code.

Removeif('Contracts / Agreements to be Approved', ID =galOverview.Selected.ID)

Please click Accept as solution 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.

Was this reply helpful? Yes No
claudia 208 on at

Like (0)

Report

Thank you for your answer.

I receive the following error: Incompatible types for comparison. These types cannot be compared: Number, Control
We cant evaluate your formula because the values beign compared in the formula aren't the same type)

Was this reply helpful? Yes No
claudia 208 on at

Like (0)

Report

Thank you for your answer.

I receive the following error: Cannot use a non-record value in this context "galOverview.Selected.ID".

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Hi @claudia ,

Please try below code.
Removeif('Contracts / Agreements to be Approved', ID=Value(galOverview.Selected.ID))

Was this reply helpful? Yes No
claudia 208 on at

Like (0)

Report

I still receive an error. Please see below.

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (1)

Report
Hi @claudia ,

One more try

Remove('Contracts / Agreements to be Approved',LookUp('Contracts / Agreements to be Approved',ID=galOverview.Selected.ID))
Also could you please confirm the datasource you added in Gallery control is same as the dats source you are trying to remove from ?

Please click Accept as solution 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.

Was this reply helpful? Yes No
claudia 208 on at

Like (0)

Report

The data source is the same

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Hi @claudia ,

Did the previous mentioned code work in your case ?

Was this reply helpful? Yes No
claudia 208 on at

Like (0)

Report

Unfortunately not ☹️

Was this reply helpful? Yes No