web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get a specific value f...
Power Automate
Answered

Get a specific value from a cell using its Id in Get a Row

(1) ShareShare
ReportReport
Posted on by 33

Hi Power Automators,

I am trying to extract an email addresses from an Excel sheet in order to send an email using Send a Mail V2 to that address. However I can't figure out how to get that specific email address using its Id. The email address could be in any row in my excel sheet, so I cannot use first/last output expressions. Please see attached my current flow. Thank you in advance for your help. 

Regards, 

Newbie to PA

Flow.png
Categories:
I have the same question (0)
  • Verified answer
    Garima_PowerPlatform Profile Picture
    170 on at
    Hi
    Ensure your Excel table is formatted as a proper table with headers.
    The table must have an ID and Email column.
     
    Please follow these steps

    1. Manually trigger a flow
    2. List Rows from Excel
    3. Filter Rows for the Specific ID
    • Add a Filter array action to filter the rows fetched from Excel.
    • Configure Filter array:
      • From: Use the value from the List rows present in a table action.
      • item()?['ID'] eq 'YourTargetID'
    4. Use a Compose action to extract the email address from the filtered result.
    Use this expression in the Compose action:
    first(body('Filter_array'))?['Email']
    
    
    5. Send an Email:
    • Add the Send an email (V2) action.
    • In the To field, use the output of the Compose action (dynamic content).


      Flow will be like this

       

    • Trigger (e.g., Manually trigger a flow).
    • List rows present in a table (Excel).
    • Filter array (filter rows by ID).
    • Compose (extract email).
    • Send an email (use the email from Compose).

      "Please mark me as verified if this was helpful to you."

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard