Answered

Remove a row from a collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want to delete a row in my excel table with this: Remove(myExcelTable; ThisItem) The button to do that is in the gallery.

But why does that don't work? That here also don't work: RemoveIf(Bestellungen; true)

The error: No line with id 5 was found.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

RyanVH 145 on at

Like
a
(1)

Report
Copy link

Link copied!
I'm not sure if you posted a typo but the correct syntax would be

Remove(myExcelTable, ThisItem)

use , instead of ;

But that probably won't be your problem because you would get an error.

I just tried it on an app myself and it worked perfectly.

Make sure the excel file isn't open anywhere. That could give problems too
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I from Germany, so I have to use ; instead of ,
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

Does your Excel record have a unique identifier?

If so you can try

RemoveIf( ExcelTable; Identifier=ThisItem.Identifier )

You might also have a look at this video from Shane Young @Shanescows and consider a SharePoint alternative.

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I cannot use sharepoint, my Admin delete everything in Sharepoint.
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

Yes, I remember that now (you need a discussion with your Admin - they should support the business, not dictate to it) - you need a unique identifier in your Excel record, then it will work.

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.
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Do you want to remove a record once click the button within the Gallery?

Could you please share a bit more about the scenario?

I have made a test and the situation is confirmed on my side.

Remove(Table1,ThisItem)

Here is my Gallery configuration:

Please check if it helps.

Regards,

Qi