Use JSON Data individually

(0) Share

Report

Posted on by Kryptic

Hi,

FYI: I'm a noob when it comes to JSON and PA.

I managed to get Data from PowerApps into Power Automate, i used Parse JSON to format it.

I would like to use the Data i have, (firstname, lastname, email) to send an email.

But when i create a step with 'Send an email', i can only use the Body of the Parse JSON as dynamic content, i cant use any of these strings seperately, i want to be like below:

I have the same question (0)

All responses (3)

Answers (1)

Pstork1 68,271 Most Valuable Professional on at

Like (1)

Report

Re: Use JSON Data individually

The dynamic content box can be overactive when filtering out content because it thinks its the wrong data type. try using a Compose just prior to the send an email and see if you can access the fields there. If not try generating the JSON schema again from a sample run. Its the schema that makes those values available.

Was this reply helpful? Yes No
Kryptic 76 on at

Like (0)

Report

Re: Use JSON Data individually

Compose doesn't show the variables either, a new scheme also didnt work unfortunatly

Was this reply helpful? Yes No
Verified answer

Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report

Re: Use JSON Data individually

Try accessing one of the values before you add the Apply to Each loop. Doing so should add the apply to each loop itself. Then the values should be visible. Otherwise there is definitely something wrong with the schema. I would remove the $schema line from the JSON schema. That is normally a reference to a schema stored elsewhere.

Was this reply helpful? Yes No