Sending an e-mail from an excel file table with certain triggers

Like (0) Share

Report

Posted on 2 Apr 2024 07:56:34 by BNaghi34

Hello all,

I am trying to send an e-mail when a certain value in my sharepoint list is selected from a drop down list. I get that part right but the problem is that I want Power Automate to take the e-mails from an excel file.

Basically, when I select a value from my sharepoint list I want power automate to go to a specific excel file table and take the e-mail address column and send the e-mail to the addresses in that column.

PS: I have the excel files in sharepoint and I tried with multiple excel file automation templates, could not get it right.

I am sending snips with my flow and the excel file, any help would be appreciated on this matter. Thank you in advance!

All responses (2)

Answers (1)

Verified answer

Perumal 604 on 02 Apr 2024 at 09:36:00

Like (1)

Report

Re: Sending an e-mail from an excel file table with certain triggers

An issue arises due to confusion with the "Key column" and "Key value" parameters in the "Get a row" action.

For the "Key column," you have to specify the identifier 'Carrier/lane' based on the key value.
v-yetonggu-msft on 02 Apr 2024 at 09:23:23

Like (0)

Report
Re: Sending an e-mail from an excel file table with certain triggers

Hi @BNaghi34 ,

Do you want to extract the information in the row in the excel table where the Carrier/lane is equal to the Carrier Value of the modified item, and then send the information to the email address of that row?

If so,I did a test for your reference.

In my scenario:

1))The trigger I use is when an item or file is modified.

2)List all rows in the table.

3)Filter out the rows in the excel table whose Carrier/lane is equal to the Carrier/Value of the modified item.

4)Use 'Select' to extract email addresses in filtered rows.

5)Create html table: send filtered row information as a table to a specific email address.

item()?['Carrier/lane'] item()?['E-mail address'] item()?['Name-Optional'] join(union(body('Select'),body('Select')),';')

My Email Inbox:

Best Regards,

Sunshine Gu