Delete only selected item in sharepoint list

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
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.

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

Like (0)

Report

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?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report
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

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

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No