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

(1) Share

Report

Posted on 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

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Garima_PowerPlatform 170 on at

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

Was this reply helpful? Yes No