Answered

Delete Gallery row record and same Sharepoint record as saved in JSON format

(0) Share

Report

Posted on by knsrinath

527

I have a Sharepoint list (visitorsRegistration_New), Column (canteenJson) and patching data in JSON format as mentioned below along with GUID reference number.

I am able to fetching the JSON formatting data to Gallery as a collection name is colFilterList

I want delete one row in Gallery displaying as a collection. I have used the following formula Onselect Delete button.

Remove(colFilterList,ThisItem)

This formuls is deleting Gallery row only. But I need to delete same row in Sharepoint JSON record also.

Request you help me to delete Sharepoint record.

Thanks & Regards

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @knsrinath ,

If you're collecting the record's ID along with the JSON, you can use "RemoveIf()" to delete it.

RemoveIf( datasource, ID = ThisItem.ID )

Or, if the record in your gallery is the exact same as the record in your list, a single "Remove()" works too.

Remove( datasource, ThisItem )
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WiZey

I have a JSON array saved in one ID and ID = 28

[
{
"Date": "2023-03-27",
"Department": "P",
"Employee_ID": "5",
"Employee_Name": "H",
"Indenter_Name": "Bu",
"Meal_For": "Dinner",
"Meal_Type": "OT",
"Order_No": "00030",
"Order_Shift": "Shift-A",
"Remarks": "12",
"Shift": "A+4",
"refNo": "0197e089-be89-4bc3-939e-f99c5688c5f5"
},
{
"Date": "2023-03-27",
"Department": "PU",
"Employee_ID": "50",
"Employee_Name": "EP",
"Indenter_Name": "Bu",
"Meal_For": "Dinner",
"Meal_Type": "CP",
"Order_No": "00030",
"Order_Shift": "Shift-A",
"Remarks": "32",
"Shift": "B+4",
"refNo": "9df21087-da2a-4c6d-9878-0f6fe4a0e08c"
},
{
"Date": "2023-03-27",
"Department": "P",
"Employee_ID": "50",
"Employee_Name": "T",
"Indenter_Name": "B",
"Meal_For": "Dinner",
"Meal_Type": "CP",
"Order_No": "00030",
"Order_Shift": "Shift-A",
"Remarks": "33",
"Shift": "A+4",
"refNo": "8a80406d-afe8-4787-a04e-8305d41259b9"
}
]

Out of 3 I need to delete only one record mentioned in below

{
"Date": "2023-03-27",
"Department": "PU",
"Employee_ID": "50",
"Employee_Name": "EP",
"Indenter_Name": "Bu",
"Meal_For": "Dinner",
"Meal_Type": "CP",
"Order_No": "00030",
"Order_Shift": "Shift-A",
"Remarks": "32",
"Shift": "B+4",
"refNo": "9df21087-da2a-4c6d-9878-0f6fe4a0e08c"
},

Thanks & Regards
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I see, you need to update a record's column, not delete a whole record.

In that case, I'd suggest using "Patch()" to edit your record with a new JSON value depending on what's remaining in the gallery.

First, you delete the records in your gallery to clean up the JSON.

Then, the save button update the record with what's left of the JSON.

I recommend putting the code in a save button, because the delete button would not be a good fit for updating the record in the list.

Patch( datasource, LookUp(datasource, ID = Record.ID), { JSON : newJSON } )

I'm not really sure how you constructed your JSON, so I'll leave that part to you.
Verified answer

knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WiZey

In one ID 3 records are saved in JSON format.
I can not delete entire ID. I want to delete only one record from JSON array

Is there any possible to delete single record with GUID number instead of ID
Thanks & Regards