Unanswered

Remove doesn't remove record from excel

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

I am using the remove command as so:

Remove(Table1, 'Main Data Table'.Selected)

However this doesn't actually change the table, only the display on powerapps' side. Is there a way to have this command change the table itself in the same way many of the other powerapps commands do?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi Colleen,

If your data source is a table named Table1 in an Excel file residing in either DropBox or OneDrive and you have selected a record in either a datatable control or a gallery control, Remove (Table1, Gallery1.Selected) or Remove(Table1, DataTable1.Selected) should remove it from the Excel table. However, you may want to check to see if the data source for your Remove function is a collection derived from an excel data source and not the data source itself. If it is, that would explain why the record is removed from the display and not from the underlying Excel table.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Drrickryp,

Unfortunately that isn't the case which is why I am confused as to why it isn't working. The formula is connected directly to the DataTable from excel and yet still isn't changing the table. My other commands linked to the same table (submit, edit etc) are working and changing that table.

Was this reply helpful? Yes No
Brian Dang 3,976 on at

Like (0)

Report
Hi @Anonymous,
Can you clarify a few things more explicitly:
You have an OnSelect formula in your DataTable that is expecting the selected record to be removed
Is the selected record removed from the datasource?
If I understand correctly, the selected record does not appear removed from the data table.
Can you share a session ID where you can get this to occur?
https://aka.ms/pa/sessionid
https://aka.ms/pa/sessionid-web

Brian

Was this reply helpful? Yes No
oscarmqz 4 on at

Like (0)

Report

Hi @Anonymous were you able to make this work? I'm having the same issue...

Regards,
Oscar

Was this reply helpful? Yes No
Mr-Dang-MSFT on at

Like (1)

Report
Hi @oscarmqz,

Are you having the exact same issue as @Anonymous?:

Data stored in Excel

Using Remove(Table1,DataTable.Selected) to remove a record

Record is removed in app, but not in the underlying spreadsheet

Was this reply helpful? Yes No
civector 6 on at

Like (0)

Report

I am having exactly this problem with deleting a row from Excel using PowerApp.

My PowerApp uses both a SharePoint List and an Excel file stored in SharePoint. I create, update and delete the same data from both sources. I use the SharePoint List as my main source for the app, but add the Excel file so that I can download it and update a desktop version of the file (with macros) to refresh the desktop version. This way, I can use the app to provide an interface for viewing and modifying the data and use VBA to refresh that data for various users.

With "Assets" as the SharePoint List and "AssetsXL" as a table in Excel:

Remove(Assets,LookUp(Assets,Title=varTitle));
Remove(AssetsXL,LookUp(AssetsXL,Title=varTitle));

The SharePoint List remove the row as expected but the Excel Table does not.

Was this reply helpful? Yes No
HaoZhong 9 on at

Like (0)

Report

It's very unstable if you use excel online with Powerapps especially dealing with over 10 records. I have issues removing record and filter even thought there is less than 2000 rows in my Excel. I won't trust my app to function correctly if I use it to write or remove Excel Online. Please do not waste your time using Excel Online. I heard you should use Sharepoint instead if you want to use fee stuff. Excel online is probably good for prototyping or before your actual database is up and running. Excel Online plus Powerapps = unpredictable results!!

Was this reply helpful? Yes No