Power Platform Community Forum Thread Details

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:

Using flows

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