1

My Power Automate solution produces the desired values except I can't figure out how to remove the HTML metadata in the email output. Instead of:

{"__metadata":{"type":"SP.FieldLookupValue"},"LookupId":958,"LookupValue":"Toyota Camry"}

I just need the value (Toyota Camry). Please see the attachment for an illustration. I also tried the HTML-to-text feature and it produced the same email output.

Any ideas will be appreciated.

Power Automate solution showing current and desired output

Improve this question

1 Answer 1

Reset to default
1

Try using below expression in "Check previous status" action:

body('Send_an_HTTP_request_to_SharePoint')['d']['Car']['LookupValue']
Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.