Retrieving an Email Address from a SharePoint List with Power Automate.

(2) Share

Report

Posted on by CU16021406-1

1,066

Dear Experts,

I have a Compose action called “Name” which contains a name.
What I would like to achieve is to get the email address of that person by searching in
SharePoint list called “LookupLijst”, where both the name and email address are stored.
The goal is to retrieve the corresponding email address and store it in another Compose action.

Example:

The Compose “Name” contains: “Charlie Chaplin”
Power Automate should then look in the SharePoint list LookupLijst, where an entry exists such as:

column Name | column Email
Charlie Chaplin | charliechaplin@zxc.com
It should retrieve the email address and place it into another Compose action.

How can i do that? Gr. P

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

vipuljain03 673 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@CU16021406-1 - You are already using SharePoint "Get Items" action where you can write a Filter Query so that Power Automate only returns the matching row.

E.g. - Name eq '@{outputs('Name')}' => Here Name is your existing Compose action.

In the next Compose action (where you want to get the email address), use the expression: first(body('Get_items')?['value'])?['Email']

This will:

Take the first matching record

Extract the Email column value

========================================

If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like to help others in the community find the answer too!

Thanks,

Vipul

Was this reply helpful? Yes No
CU16021406-1 1,066 on at

Like (0)

Report
Copy link

Link copied!

Unfortunally it did not work:

Was this reply helpful? Yes No
11manish 2,265 on at

Like (0)

Report
Copy link

Link copied!

The video below might be helpful:

https://www.youtube.com/watch?v=I8FdUmECAn8

Was this reply helpful? Yes No
Suggested answer

Haque 2,916 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU16021406-1,

Can you please share the internal name of the column you are trying to retrieving corresponding email address?

The oData query will be based on internal name of the colum.

Filter Query: Title eq '@{outputs('Name')}'

Please replace Title with the internal name (from your example it is column Name) of the name column in your list

How to get the internal name of a SP list column:

1. Under Columns, click the column name.

2. Look at the URL in your browser — you’ll see something like: .../FldEdit.aspx?List=%7B...%7D&Field=My_x0020_Column

Here:

My_x0020_Column is the internal name and pleae note that spaces become _x0020_, and special characters are encoded.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No