Remove Record

[Sidhant_02]

Hi everyone,

I was implementing the remove functionality from the gallery (data source as Excel file). I was referring the documentation section for remove() but was getting an warning: 

The format for OnSelect for Delete button as per the format. I have used a flag varShowPopup to rest the flag to false as the next statement after remove to hide the pop-up box.

[WarrenBelz]

HI @Sidhant_02 ,

Assuming you have a unique identifier column in your record (replace with the field name)

RemoveIf(
   Contacts,
   IdentifierName = Gallery1.Selected.IdentifierName
)

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.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Sidhant_02]

So the IdentifierName should be replaced with one of the columns from my Excel?
How to make a column unique?

Why cannot we use only Remove to remove a record instead of RemoveIf where in we have to specify a condition?.

[timl]

Hi @Sidhant_02 

Your screenshot shows that you've imported the Excel data into your app.

Data that you import into Excel is static/read-only, and you won't be able to add or remove records.

Instead, if you save your Excel spreadsheet to OneDrive and connect to it from there, your original Remove formula will work.

There are more details on how to do this here.

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-excel

[Sidhant_02]

I will try this

[WarrenBelz]

@Sidhant_02 ,
I was simply giving you an alternative I know works. If you have a column where no two records in the table have the same value, then that is a unique identifier. I would suspect that in the Contacts Table, that is the name of the person. However I now see @timl 's observation and he is correct - you simply cannot delete records from static data.

[Sidhant_02]

Refer my reply

[Sidhant_02]

Hi, 
I had created a new excel on my OneDrive and after connecting it to the Vertical Gallery when I inserted a label the record was not being displayed even after entering proper expression. Could you please let me know what is going wrong @WarrenBelz @timl 
The Id tab which power apps usually generates when we connect it to an excel is  not getting displayed. For the first time it was working fine but there was one issue with Cancel button so I tried adding few records but it threw error so I created a new file but now the records are not shown.