Remove value from string

[KrzysztofFP]

Hi,

This is a part of my JSON string

"actions": [
{
"type": "Action.Submit",
"data": {
"Environment": "Default-d70890a4-3e",
"ApprovalTitle": "TEST",
"ApprovalLink": "https://flow.microsoft.com/",
"ApprovalName": "19721f7e-8279-4de5",
"OnBehalfOfNotice": "Requested by Krzysztof <k@gmail.com>",
"CreatorName": "Krzysztof ",
"CreatorEmail": "k@gmail.com",
"CreationTime": "\"Thursday, 17 March 2022 12:47 GMT\"",
"MessageTitle": "TEST",
"Details": "Hi,\nThere is a new invoice that needs to be processed by our Finance Team. Please review it (accept/decline). **_You have 5 days to do it_**, if you won't then the invoice submission request will expire (Finance Team will be notified).\n\n**Requester:** ()\n\n**Invoice No:** \n\n**Issue Date:** \n\n**Submit Date:** \n\n**Total cost (net):** \n\n**Description:**\n\n\n**Cost distribution:** \n| MPK | Group | Material, service | Cost | \n|:-----------|:-----------|:-----------|:-----------| \n \n\n\nRegards,\nFinance & Admin Bot",
"Options": [
"Approve",
"Reject"
],
"SelectedOption": "Approve",
"ActionType": 1
},
"title": "Submit"
}
]

and i need to remove from it Details item 

"Details": "Hi,\nThere is a new invoice that needs to be processed by our Finance Team. Please review it (accept/decline). **_You have 5 days to do it_**, if you won't then the invoice submission request will expire (Finance Team will be notified).\n\n**Requester:** ()\n\n**Invoice No:** \n\n**Issue Date:** \n\n**Submit Date:** \n\n**Total cost (net):** \n\n**Description:**\n\n\n**Cost distribution:** \n| MPK | Group | Material, service | Cost | \n|:-----------|:-----------|:-----------|:-----------| \n \n\n\nRegards,\nFinance & Admin Bot",

but i don't have idea how... anybody can help ? 🙂

[v-jefferni · Accepted solution]

Hi @KrzysztofFP ,

You can use below functions to achieve your need:

concat(first(split(variables('string'),'"Details":')), '"Options"', last(split(variables('string'),'"Options"')))

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.