Answered

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

(0) Share

Report

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Verified answer

Perumal 604 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No