Unanswered

Send e-mail to subjects from a table in excel

(0) Share

Report

Posted on by YDRDK

Hi,

I am trying to make a flow that automatically sends an e-mail to the people that I have in a table in excel (I have the name and e-mail in the table) every time something new is added to a folder in Sharepoint.

This is what I am trying to do:

I keep on getting an error in the Key Value in the "Get a row" part. What should i write in that field?

Does anyone know if I can do it in a different way?

Thank you!

Best,

Majken

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@YDRDK , for Get Row action, are you looking to get specific row from excel, if yes, then that must be based on some value e.g. if there is an email column in excel which has all emails and you want to get row which has abc@test.com email value, then in Get Row Action in Key Column, Email column needs to be selected, and Key value will be abc@test.com

Now as you are looking to send email to people in excel, do you want to get all rows from excel to get emails from all rows, or want to get a specific row?

Was this reply helpful? Yes No
YDRDK 48 on at

Like (0)

Report

Hi @annajhaveri,

I am trying to get several rows in the table in Excel - how do I do that then? I only have the one option to choose from with rows.

My table looks like this:

I need the name as well in the e-mail.

I hope you can help me solve this as well, as I have tried a lot now and I have googled a lot as well, without getting a good solution.

Best,
Majken

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

How many rows do you have in your excel that you want to get in the flow? Is it a lot of rows?

You can use "List rows present in a table", as shown in screenshot below. If you can apply filter query that would be better so that you only fetch those rows that you need, otherwise you can skip filter query

Then loop through the rows using Apply to each action as shown below, here you can get value of Email and Name column. In Apply to each action, select Value (list of items) from dynamic content. And then inside apply to each action, add Compose action to get value of Email, select Email from Dynamic content, same way add another compose action to get value of Name.

Was this reply helpful? Yes No
YDRDK 48 on at

Like (0)

Report

Thank you so much Anna - that worked and it is now fixed.

For now I only have 2 people in my table, however that is only because I am just testing at the moment, when I get the real data in there will be a lot more emails in the table.

Best,
Majken

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

okay, how many rows do you expect the excel to have real time?

Was this reply helpful? Yes No
YDRDK 48 on at

Like (0)

Report

I don't know for sure, but I think probably around 20/30 rows.

I hope it can still work with that amount of rows.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Yes that should work fine.

Was this reply helpful? Yes No