web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Remove value from string
Power Automate
Answered

Remove value from string

(0) ShareShare
ReportReport
Posted on by 4

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 ? 🙂

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @KrzysztofFP ,

     

    You can use below functions to achieve your need:

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

    vjefferni_0-1647844511062.png

     

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard