Answered

Remove record from SharePoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 I don't think I get it.. :S I deleted the remove in the other one

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 Thank you for helping, but I have difficulties seeing what I am doing.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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});

Was this reply helpful? Yes No