PowerApps delete SharePoint list item, related items, and confirmation 

Each time I try to do something new (to me) I can always count on you to have tackled the problem already. Thank you Shane for sharing and for making me look like I know what I'm doing.

The production quality of these videos are getting better and better haha

Hi Shane, it was a brilliant power apps class, we are learnig a lot of things with your tips and apps, great job guy, congratulations and peace

Thank you Shane - this is awesome. I need to bring in a spo list based on lookup to ref ID of parent record, into a collection and then mess w that collection (edit, add, delete existing) and patch the collection back to the list to replace existing 😮. Based on this and other records I’m thinking of just having 2 separate galleries - update database and new items.

Thanks for another great video! One problem I have run into with the Remove function is that it is pretty much impossible to use it in a For All loop (boo!!! ☹) because it does not like "ThisRecord.". Not the end of the world, but it would be nice! Also, I usually make my popups by using a container. It's nice because then you can control the visibility just with the container and it works great as a parent. I have been container obsessed as soon as I saw them show up in the controls lol.

Nice video Shane. Hovever, when I delete child parent and child items, I always start with deleting the child items, and in the end the parent item. I have not experienced problems with this, but your idea with the confirmation box is awesome, so I think I am going to rebuild my delete function ;). Have a great day, and thx for the great tips

Worked like a charm. Thanks!

Thanks Shane. Greetings from Brazil!

I have learned a lot from your video, what a great ideas, very helpful. Thanks a lot.

Great video, although remove('listname') didn't work for me. had to use Remove('listname", Lookup('listname', title = "specific_item"). but all in all your video steered me in the right direction..it just took a little more. Good job as always Shane.

You rock Shane. Thanks for all the help!!

Thanks so much from Spain. Your videos are amazing and you are my heroe. Best wishes for Christmas.

Thanks yet again Shane, just what I needed right now 😘

Heya! I was looking for this tip today!! Haha, tkx for share it!!

I wouldn't recommend using RemoveIf function because it does not work if you have more than 3000 items on a SharePoint list. The function fetches first 3000 items and then remove from those fetched items. Let's say you have 4000 items on the list and you're trying to remove the 3005th item with RemoveIf, it will not work because that specific record was not fetched by RemoveIf. Instead, you should fetch with the Filter function, put that into a collection in PowerApp and use ForAll to remove. That way you can be sure that these items will be removed from the SharePoint list.

Thanks for videos, some of the more helpful out there. Can we see a video showing how to Patch/Collect to a list form multiple combobox:)

great video Shane! You made me laugh at 23:43 - I've done that!

Perfect video, exactly what I needed!

Love your help!!! I am trying to set a combo to Blank/Null when a certain value is selected in another combo. Can you please provide a clue on how to do this. Thanks

Saved my back, like always, thanks

Thank you, very helpful indeed

Thank you very much for showing an awesome video for deletion in Canvas apps. I've a query. I've two lists in SharePoint. One holds current list and another is Archive list. When in my Canvas app, I clicked on my Archive button, it immediately transfer data from current list to archive list. I want to undo it. What is the way I can make an undo in canvas app or any other solution that will store a temporary archive list before moving to archive from current one but on click it will back again in the current list? Please let me know your suggestion.....

Brilliant Shane ❤️.

So fun, i was figuring it out two days ago how to do that :D hope it will help some day :)

Top Shane, você é muito foda! (you are very good)

Why rectangle for popup? Isnt better to use container? More control and better easier and quicker to arrange...

great stuff shane, have you played with the new IfError feature? would love to see a video on how to appropriately use that in the future!

Thank you , my hero!

I'm having trouble combining this with a text search function. I would like for users to be able to search a sharepoint list, and delete an item if they want.

Hello, thanks for all these wonderful videos! does this work also if the data source is excel which is uploaded in Onedrive?

How do we do in dataverse table. How to set pop up for confirming deleting a row in dataverse table.

Have you tried with soft delete. It will leave a blank space in the gallery which is annoying.....Need some inputs from you Sir.

Hey Shane Great Video thanks for it. I have one question on confirm box if we Click on the delete button only data should remove . have you tried to click outside of confirm box. Scenario click delete icon on the gallery confirm box will pop up click outside on anywhere from confirm box on Rectangle its deletes data with out pressed button its removing the value.

Hi Shane. Thanks for all these videos! My company asked me to make some flows but still insists on using Infopath for now. I have lookup lists but can't use them across multiple collections. So I am trying to make a flow that will copy/update/delete those items to the other sites where they serve as lookups. Not sure that's the smartest way, but I can't use power apps yet. Do you know if there is an easy way to Delete an item from a duplicate list, when we delete it from the primary list? Thanks!

Shane, Great channel! I am a new Sharepoint user, and have been tasked with creating a corporate intranet site. One of the requests is a Classified Ads type list. I am attempting to create a Power App, using a Sharepoint list. I was looking through all of your videos, but thought I would ask.. have you ever tackled anything like that in another video? Am I headed down the right path? Thanks in advance! - Marty

Thanks Shane

Love your content. Im looking for the video where you build the child relation of this app. Is the video on your channel? Much love from germany!

Thanks Shane Young for the content, it is spectacular I have a problem and that is that when I execute this action it does not delete the record, the message I receive in the formula is "ThisItem = this formula uses the scope, which is not currently supported for evaluation "Thank you very much for your help, greetings from Colombia

Can You do video on how to delete a attachment from sharepoint list using powerapps button

Great video at the right time! I was just looking for a solution how to delete items and subitems. But one remark: Could you please speak not so fast :-). As a non-native speaker it is sometimes very hard for me to follow your explanations

How can i remove if the item in gallery is equal to zero. My code is remove(product,if(prod-prod2=0,gallery.selected))... i need to patch update the new data in another sheet. And remove the item if it is equal to zero

Hi, Sir. I have made a service desk app from already given template using sharepoint... Problem is that i have to add and delete some items from sharepoint so that it suits my needs but I am pretty confused about how to add or delete items in sharepoint datasource so that it gets reflected in service desk powerapps... I can easily add or remove entry from sharepoint but it is not getting reflected in service desk app.. I need your guidance.. Thank you.

Thanks for a great video. Definitely will subscribe. I've run into an odd issue with the Removeif command though. My delete button is simply supposed to remove items from my list that have a Date less than the Date I supply in a date picker. Works a charm unless there are more than 62 items that fit that criteria. If there are even 63 items that are within the date span, 62 will be deleted and 1 will be left. Any idea what could be causing that?

Hey Shane. Thanks for your video. I am trying to use same formula(Remove(My_Source_Data,Gallery2.Selected)) in PowerApps, but I am getting an error (Incompatible Type.The collection can't contain values of this type).

When using the Remove(collection, thisitem) it removes random items from my gallery it isnt connecting to the correct line? Do you know why?

great video! I'm having an issue with my trash can icon in a gallery. When I do "Remove(Collection, ThisItem)" it deletes the previous row??? What am I doing wrong?

This is helpful for deleting from the gallery, but it doesn't like the code for removing a list item from my data source.

Hi Shane, i was using Lookup within Remove function to remove child records, but its only removing first child record not all of it, i was wondering if i should use ForAll function as well, but how, if you can help. Thank you

Is there an alternative to delete/remove like a Deactivate?

CDS or Datavers user interface? With Microsoft SQL Management Studio I can display data (I cannot change tables or data records) Are there any tools for creating tables, views, etc, ... and for manipulating data? Thank you

record is getting deleted from the database but not from ui any better suggestion for this

Hi Shane, i try to remove the whole Data from a Colum but i don`t want to drop the Colum and i dont want to remove the whole table. Do you have an Idea?

Is posible to make download button?

Hi Shane, Thank you for the great content! About your code at 13:40, the remove part alone works fine, but when I put a semicolon and the second part where you setup the variable, it doesn't work anymore and I get the following message "This formula has side effects and cannot be evaluated". I can't figure out what am I doing wrong ...

thx

bah

Hi! It dosen't work for me: Remove(colTxtSal,ThisItem)