web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Removing records from ...

Power Apps

Answered

Removing records from Excel Online SH

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi

I have another problem that I don't understand.

I have Excel Online (Business) SH applied in the application - "Table2" records are saved there. Excel yearbooks are also saved in the SH list.

Trying to delete a record from Excel and SH list the common denominator is ID_creation

I found such a solution on the forum

Remove(Table2, Filter(Table2, ID_creation = Gallery16.Selected.ID_creation))

unfortunately does not work

Thanks for all the answers

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

WarrenBelz 156,736 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try this

RemoveIf( Table2, ID_creation = Gallery16.Selected.ID_creation )

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.

Visit my blog Practical Power Apps
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I tried the funuccion presented by you before writing the post.
I was only able to solve the problem by writing something like this
Remove(Table2, First(Filter(Table2, ID_creation = Text(Gallery16.Selected.ID_creation))), All)
WarrenBelz 156,736 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

If you can consider SharePoint instead of Excel as a data source, you will find this and any other issues will go away.

Join the conversation