web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Parsing text to JSON

Power Automate

Answered

Parsing text to JSON

(0) Share

Report

Report

Posted on by fallabe

I have the following text below

Old email: someone@microsoft.com

New email: someone1@microsoft.com

Now, I need to transpose this string to JSON using existing Power Automate functions, e.g.

{

"old_email": "someone@microsoft.com",

"new_email": "someone1@microsoft.com"

}

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @fallabe ,

I've made a test for your reference:

Value:

{ "@{split(split(variables('Text'),decodeUriComponent('%0A'))[0],':')[0]}":"@{split(split(variables('Text'),decodeUriComponent('%0A'))[0],':')[1]}", "@{split(split(variables('Text'),decodeUriComponent('%0A'))[1],':')[0]}":"@{split(split(variables('Text'),decodeUriComponent('%0A'))[1],':')[1]}" }

Result:

Best Regards,

Bof
takolota1 4,980 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@fallabe @v-bofeng-msft

Are the strings separated by a linebreak, or is there no separation?

If there is a linebreak, then you could split on that & then use a couple replaces to do all this without manually typing everything out in a variable...

json( concat(join( split( replace( replace( replace(InsertDataHere, decodeuricomponent('%0A'), concat('"', decodeuricomponent('%0A'))), 'Old email:', '"old_email":"'), 'new_email:', '"new_email":"'), decodeuricomponent('%0A')), ','), '"') )

Join the conversation