Answered

Unable to create and set a variable to hold array element

(0) Share

Report

Posted on by JWessel

Apologies if this seems trivial but I've had no luck in getting something to work. I have the following Select in my flow

What I want to do is to take that output value, put it into a variable so that I can use the email address in a send email operation at the end of the flow. Any help is appreciated.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (3)

Verified answer

Ellis Karim 11,931 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @JWessel ,

In the Select action, switch to text-mode then enter your expression for the email into the Map. Example:

The output will be an array. If the result will only ever have one email address in the output you can use the First function and then reference the email property. Please provide more info.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
Pstork1 69,018 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
use the first() function to get the record out of the data select array and manually reference the email key.

first(outputs('Select'))?['email']

Was this reply helpful? Yes No
JWessel on at

Like (0)

Report
Copy link

Link copied!

@ekarim2020, what is the full json expression? Apologies, I am not familiar with that function

Was this reply helpful? Yes No
JWessel on at

Like (0)

Report
Copy link

Link copied!

@Pstork1 I tried the first function and it failed because result of Select is an object and not an array. I'm going to try the json function mentioned above and then try using the first function.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,931 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @JWessel ,

The expression in the previous screenshot was just an example. For your data it will be:

item()?['SendTo']

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
Verified answer

Pstork1 69,018 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You could use just the first function in an object variable or a compose. If you want it in a string variable then you have to manually add the field name as I did in the code above. That's what the ?['email'] is for after the first function.

Was this reply helpful? Yes No
JWessel on at

Like (0)

Report
Copy link

Link copied!

@ekarim2020 , @Pstork1 both of you have been extremely helpful in a solution. I will try to mark both of the inputs from you as solutions.

Was this reply helpful? Yes No
JWessel on at

Like (0)

Report
Copy link

Link copied!

I did realize that I already had an array earlier in the flow so did not have to use any conversion from object to an array. I've been virtually banging my head against the wall on this full flow out of Power BI report for a couple days now and you and Ellis have been the pain relievers and repaired the drywall at the same time. Many Thanks !!

Was this reply helpful? Yes No