Delete only selected item in sharepoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

May i know how to delete only selected item in sharepoint list.

For example, i have Alias, Email, Address and postcode.

And i only want to delete postcode and Address only.

I used Remove('hardware list', Gallery6.Selected) but it will delete all the list.

Kindly need your help on this.

Thank you!

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,
You can Use Patch()
Patch( 'hardware list', {ID:Gallery6.Selected.ID}, { Postcode:Blank(), Address:Blank() } )

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thank you for your prompt reply.

I tried to do as follow but unfortunately its not working.

Patch(
'hardware list',
{ID:Gallery6.Selected.ID},
{
analyst:Blank(),
Availiblity:Blank()
}
);
Notify(
"Hardware Removed Successfully" , Success);

Do you have any idea why it's not working from my side?
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

Can you try to update the expression to:

Patch(
[@'hardware list'],
LookUp([@'hardware list'],ID=Gallery6.Selected.ID),
{
analyst:Blank(),
Availiblity:Blank()
}
);

Notify(
"Hardware Removed Successfully" , Success);

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

What are the types of analyst and Availiblity column?

If they are Text, Number, Date and Person column from Sharepoint list, you need to patch Blank() to the fields. But the important premise is to enable the Formula level error management in Experimental features.

Patch('hardware list',{ID:Gallery6.Selected.ID},{ColumnName:Blank()})

If they are Choice and Lookup column, the code should be like this:

Patch('hardware list',{ID:Gallery6.Selected.ID},{ColumnName: {Id: -1,Value: Blank()}})

Hope this helps.

Sik
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I already tried that also and it's not working.

For your information the data type for :

analyst is person/group
availability is choice
Reason is text
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Is there any error message on the formula? Does the 'Gallery6.Selected.ID' return the ID of record you want edit?

1. enable the Formula level error management feature

2. try the following code.

Patch('hardware list',{ID:Gallery6.Selected.ID},{analyst:Blank(),Availability: {Id: -1,Value: Blank()}, Reason:Blank()})

Hope this helps.

Sik