Extract json from email body for import into sharepoint list

[cheezy]

Is there a way to extract a single record in json format from the body of an email to import into a sharepoint list?

 for example if this came in the email body (would only ever be a single record)

{"qCode":"Order","guid":"abc123","name":"mark","oID":"1"} 

currently we get the data as a csv from an email attachment which is converted to json and parsed in the sharepoint list but moving forward want to use json directly as above  thanks

[cheezy · Accepted solution]

i think i worked it out.

if i use "HTML to text" following "when a new email arrives" then the output of this is just the json .

i can then parse the json into the sharepoint list. Quite a simple flow in the end