Answered

Delete specific cell from collection row.

(0) Share

Report

Posted on by DarkStranger

Is it possible to delete just specific cells from a collection row. So for example, I have the below gallery with a button at the end of each row. I want to be able to click on the button for the specific row and delete the "ID" an "Name" cell content for that row. Ideally with a confirmation pop up confirm that they want to delete the item. That said, I can post that in another question.

City	Country	ID	Name
London	England	T3733	James Smith
Paris	France	X4637	Clive Vincent

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

zmansuri 6,048 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I have never encountered a situation where i have to delete specific cell. But, i think you can do it with patch.
Using patch to update that specific field with "Blank()"

Was this reply helpful? Yes No
DarkStranger 88 on at

Like (0)

Report
Copy link

Link copied!

I did try adjust my patching code that added data to the "ID" and "Name" cells to the below...

Remove(PatchingInventory, ThisItem,
{
Floor_x0020_Port_x0020_No_x002e_: Floor_Port_No_Gallery_Input_2.Text,
Equipment_x0020_Type:Equipment_Type_Gallery_Input_2.Selected.Value,
Comments: Comment_Gallery_Input_2.Text
}
)

But is seems to delete the whole row.

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Remove will delete the whole row. I am saying think of it as updating that field with another value. And that value is blank.
Insert a button. Butoon>OnClick:

Patch(PatchingInventory, ThisItem,
{
Floor_x0020_Port_x0020_No_x002e_: Blank(),
Equipment_x0020_Type:Equipment_Type_Gallery_Input_2.Selected.Value,
Comments:Blank()
}
)
This will remove comment and Floor Port no of that field but not equipment type. Understand?
Haven't tried it myself. But it should work.

Was this reply helpful? Yes No
Verified answer

DarkStranger 88 on at

Like (1)

Report
Copy link

Link copied!

I figured it it, just patch "".

UpdateContext({EditRecord:Blank()});
Patch(
PatchingInventory, ThisItem,
{
Floor_x0020_Port_x0020_No_x002e_: "",
Equipment_x0020_Type: "",
Comments: ""
}
)

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Click Accept as Solution to Close the thread if it is solved.

Was this reply helpful? Yes No
DarkStranger 88 on at

Like (0)

Report
Copy link

Link copied!

@zmansuri sorry, missed your response, but figured it out.

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Glad it worked out for you.

Was this reply helpful? Yes No