cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Remove doesn't remove record from excel

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?

5 REPLIES 5
Super User
Super User

Re: Remove doesn't remove record from excel

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. 

Anonymous
Not applicable

Re: Remove doesn't remove record from excel

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.

mr-dang
Level 10

Re: Remove doesn't remove record from excel

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

Microsoft Employee
@8bitclassroom
oscarmqz
Level: Power Up

Re: Remove doesn't remove record from excel

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

 

Regards,

Oscar

PowerApps Staff Mr-Dang-MSFT
PowerApps Staff

Re: Remove doesn't remove record from excel

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