Answered

Remove record from SharePoint list

Like (0) Share

Report

Posted on 28 May 2020 08:20:37 by Community Power Pla...

Hi,

I have this list of courses, which is two columns. The first is one that have all courses, the second the courses which one finished. But I want to make it possible for the user to delete the course in the second column if they by a mistake push the wrong one. I just can't seem to get it right.

All responses (7)

Answers (1)

Verified answer

Community Power Pla... on 28 May 2020 at 09:51:04

Like (0)

Report

Re: Remove record from SharePoint list

Solved it by using this code ClearCollect(CourseUpdateDone, LookUp(Users, Title = Office365Users.MyProfileV2().id).Done);Remove(CourseUpdateDone,ThisItem);Patch(Users, LookUp(Users, Title = Office365Users.MyProfileV2().id), {Done: CourseUpdateDone});
Community Power Pla... on 28 May 2020 at 09:04:57

Like (0)

Report

Re: Remove record from SharePoint list

@eka24 Thank you for helping, but I have difficulties seeing what I am doing.
eka24 20,921 on 28 May 2020 at 08:54:47

Like (0)

Report

Re: Remove record from SharePoint list

Please relook at the formula again. I can see Rename Column in your formula as I stated.

Also do you have a column called ID. If not replace ID with your unique Column
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Community Power Pla... on 28 May 2020 at 08:47:25

Like (0)

Report

Re: Remove record from SharePoint list

@eka24 I don't think I get it.. :S I deleted the remove in the other one
eka24 20,921 on 28 May 2020 at 08:40:50

Like (0)

Report

Re: Remove record from SharePoint list

My point are:
1. On the formula you showed, clear or delete the Last formula which is Remove....

2. Insert a checkbox into the Gallery on addition to your button in the Gallery.

3. Select the checkbox you have inserted and on the OnCheck property, put the formula I stated in my reply. This is to replace your delete formula in your original formula.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Community Power Pla... on 28 May 2020 at 08:32:14

Like (0)

Report

Re: Remove record from SharePoint list

@eka24 Can you help a bit more, I have difficulties seeing what I should put into the different elements in the code.

And what do you mean by separating the remove from the formula?
eka24 20,921 on 28 May 2020 at 08:28:53

Like (0)

Report

Re: Remove record from SharePoint list

Separate the remove from the formula.
You can insert a check box for the delete when checked and on the OnCheck, put:
ForAll( RenameColumns(Filter(GalleryName.AllItems, CheckboxName.Value = true), "IDColumn", "ID1"),
Remove(Datasource,
LookUp(Datasource,
IDColumn = ID1)) )
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.