web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Create a table and sel...

Power Automate

Suggested Answer

Create a table and select item

(1) Share

Report

Report

Posted on by kiki_musampa

27

It sounds to me like it should be pretty simple, but I can't get it figured out.

I would like to create a lookup table (or variable, I don't really care) in power automate consisting of 2 columns: name and email.

John	John@mail.com
Morgan	Morgan@mail.com
Taylor	Taylor@mail.com
Jamie	Jamie@mail.com

then I have a variable with someone's name, and I want to get their email.

Any suggestions?

Merci

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Dominik Stalzer | p... 71 on at

Like (0)

Report
Add a new Step "Initialize variable" and set the type to Array and provide the following JSON in the value field:

[ {"name": "John", "email": "John@mail.com"}, {"name": "Morgan", "email": "Morgan@mail.com"}, {"name": "Taylor", "email": "Taylor@mail.com"}, {"name": "Jamie", "email": "Jamie@mail.com"} ]

Add another step "Initialize variable" for the name you want to look up. Let’s call it LookupName.

Set the type to String and provide the name you want to find (e.g., "Taylor").

Add a step "Filter array" to filter the array based on the LookupName.

In the From field, select your array variable

In the Condition section:

Field: name
Condition: is equal to
Value: @{variables('LookupName')}

Add a step "Compose"

In the Inputs field, use the following expression: @first(body('Filter_array'))?['email']

This extracts the email field.

Kind regards

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

hi

Where does this data come from, or is it just going to be hard coded Per Dominiks response?

Need more information. There is a big difference between putting this in a Table etc.

Who is going to use the output, the flow itself or something else? Do you get in a persons name and you want to filter and get their rows data?

Was this reply helpful? Yes No

Join the conversation