web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate undefined

Power Automate

Unanswered

undefined

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

remove json content from text document and return text other than json, how to do it?

Categories:

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Can you post a screenshot of the document with more details?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

'0 NOTIFICATIONS TOTAL' , This is the output I need.

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

How is the file created ? Will the text content ever have '{'. Its easy to get if No.

1. Manual trigger.
2. Get File Content
2. Split the File content based on '}' (Here I am assuming that your text will never have { as you re not giving more details
split(outputs('Get_file_content')?['body'],'{')
3. Now access the first element of the array and trim it using the trim function to remove the whitespaces.
trim(outputs('Compose')[0])

Hope this helps!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you so much , I got the result, If I want this UST details also What change will come in Split function?

Was this reply helpful? Yes No

Join the conversation