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

Like (1) Share

Report

Posted on 11 Dec 2024 10:15:11 by RP-25090907-0

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

Categories:

Business Process Flows

Flow.png

All responses (1)

Answers (1)

Verified answer

Garima_PowerPlatform 170 on 11 Dec 2024 at 22:23:34

Like (2)

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

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."