Power Automate Email Pulling in JSON format

(1) Share

Report

Posted on by JB-08041440-0

Can anyone assist with getting the information being pulled into the email to appear as just the value?

As I understand it, the columns are Arrays due to having multiple choices in the column with the ability to select multiple if needed.

I need the email to show all the values that are chosen in the columns (most the time it is only 1 value being chosen per column). Using "Body" in the email pulls in the weird format, I have tried just the value, and status of the column with no success.

I only need the email to send 1 time when the status of the ComplianceStatus column has changed to a value of Ready to Schedule. SharePoint List Item name is actually ComplianceScheduled when I look at the name listed in the URL from the SharePoint List settings.

Here is the flow: I assume the issue is with the email Division, Department, Primary Service Location, they are the 3 arrays, all information is entered in the same occurrence.

This is the email that gets generated:

Categories:

Building flows

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

trice602 16,244 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi there!

There's a few things you can do to resolve this and I think it's pretty quick for you!

1) Remove all the for each loops.

2) Remove the body of the send email (so it's empty).

3) Drag the send email action directly inside the True condition side

4) Replace your email body with the following to get the desired values:

Provider: @{triggerOutputs()?['body/Title']} Division: @{join(triggerOutputs()?['body/Division']?['Value'], ', ')} Department: @{join(triggerOutputs()?['body/Department']?['Value'], ', ')} Primary Service Location: @{join(triggerOutputs()?['body/PrimaryServiceLocation']?['Value'], ', ')} Please schedule their compliance orientation for: Date: @{triggerOutputs()?['body/ComplianceDate']} Time: @{triggerOutputs()?['body/ComplianceTime']} Location: Call / Teams Meeting

These join expressions will handle single or multi-select values.

------------------------------------------------

⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
JB-08041440-0 11 on at

Like (0)

Report
Copy link

Link copied!

The flow is now failing and not sending anything. @trice602

When I go back into the email body it shows this

This is the entire flow with the change made:

Was this reply helpful? Yes No
JB-08041440-0 11 on at

Like (0)

Report
Copy link

Link copied!

I rebuilt the email and copied and pasted @trice602 but that conditions on the email then fail and the email won't send.

This is the email (for more context) I am trying to fix User Facing View: All I need if the JSON script to be removed and just send the values at the end.

Was this reply helpful? Yes No