cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Remove items in gallery function not deleting the correct items - random items are deleted instead

Hi all,

 

I have created an Repeating table in a gallery connected to the collection, the items in the gallery gets patched to a collection with a button outside of the gallery. This is eventually patched to a sharepoint list.

 

The issue I face is that when I create a delete button inside the gallery item as below, it does not delete the item that I intended it to.

 

 

 

 

 

Remove(ServerCollection,ThisItem)

 

 

 

 

 

For example, in the image attached, I created 5 items in the repeating table

The items are only saved and patched to the ServerCollection when I click save, and the form is then submitted and all data is patched to Sharepoint.

If i click delete on row 4, it is not guaranteed that row 4 is deleted. while it's pretty random, Mostly row 2 gets deleted first, then 3 etc. If I delete row 1, row 1 is successfully deleted.

 

Where did I go wrong here? Is it possibly because I have not yet patched items into the collection yet?

How can I ensure that I can delete the correct items in the gallery before patching it?

 

Thank you!

3 REPLIES 3
Frequent Visitor

Did you try this one - 

 

On the Delete put this formula on OnSelelect:
 Remove(Datasource,LookUp(Datasource,ID=ThisItem.ID))

 

(tried this for SharePoint list item directly and it works, not entirely sure if it holds true for collection too)

New Member

@AshwiniBhandari

Sorry if I used the wrong term. It's not a editable table, but a repeating table. So I don't want to delete the item in sharepoint.

 

What I would like to achieve is option to delete the items that I am creating it in the gallery, before adding it to the sharepoint list.

Lets say I've made a mistake, and don't need this line item anymore. 

Your formula is intended to delete the item from the source sharepoint I think (like an editable table) so that's not what I'm looking for.

 

New Member

Hi,
Have you tried this function :  RemoveIf(ServerCollection, ID = ThisItem.ID)

This should work

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (61,020)