Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to remove Extra text from power automate results

i am using a flow when someone creates a document set in SP with properties and coloumn tags as trigger

and it should then send an email with the value of a coloumn.

but it displays extra text in the resulting email {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy","TermGuid":"61dcee53-dfde-4f62-815d-9f1e745d024d","WssId":122,"Label":"Testvalue","Value":"Testvalue|61dcee53-dfde-4f62-815d-9f1e745d024d"}


How can i remove the extra text and only keep the value in email?

Super User II
Super User II

hi @daredeviln  you can use parse json



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!

If you want you can follow me at Quieres contenido en español? Síguenos en Power Automate LA

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,033)