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

[knsrinath]

Hi

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

[WiZey]

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]

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]

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. 

[knsrinath · Accepted solution]

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