cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to send information from Excel to outlook e-mail

I am trying to create instance flow for sending datas from excel to e-mail.

 

But power automate require some informations and I have no idea what does it mean.

 

What kind of information should I input to 'Table', 'Key row', 'Key value' in Excel flow? 

 

Thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-duann-msft
Community Support
Community Support

Hi @Anonymous 

 

Thank you for posting.

 

According to your description, you would like to send email based on excel file but are confused to some input while configuring flow. Here are the related information for your reference:

 

“Table”

Table is created in excel in advance while we preparing excel file. This is a identified part for which sheet you want to use from excel file. We can create table

v-duann-msft_0-1617344836374.png

 

Since you didn’t mention about your actual requirement and action you want to use, I will take ‘update a row’ action as example which contains ‘table’, ‘key column’ and ‘key value’ area together.

 

After we set up table in excel, you will be able to select ‘table’ which is detected by flow automatically.

v-duann-msft_1-1617344836377.png

 

For ‘key column’ and ‘key value’, they are used for identify unique value from your excel.

 

Key Column: It can be whatever column you want in a table that can serve as a reference to indicate what is the row that will be modified. Make sure that it has unique values, because an error will be generated if duplicate values in this column are generated.

Key Value: It is whatever unique value you want in the Key Column to indicate what is the row that you want to update.

Example: If you have a table with two columns: Column1 and Column2 and Column1 has numbers from 1 to 5 and you want to update the row that contains a value of 2 in Column1, then "Column1" is your Key Column and the value "2" (without the quotes) becomes your Key Value.

 

If you still have trouble building a flow, just explain me your requirement including 'information format in excel'/'information wants to be sent via email', I can help you or provide some tips for you.

 

Hope the content above may help you.

 

Best regards,

Anna

View solution in original post

4 REPLIES 4
v-duann-msft
Community Support
Community Support

Hi @Anonymous 

 

Thank you for posting.

 

According to your description, you would like to send email based on excel file but are confused to some input while configuring flow. Here are the related information for your reference:

 

“Table”

Table is created in excel in advance while we preparing excel file. This is a identified part for which sheet you want to use from excel file. We can create table

v-duann-msft_0-1617344836374.png

 

Since you didn’t mention about your actual requirement and action you want to use, I will take ‘update a row’ action as example which contains ‘table’, ‘key column’ and ‘key value’ area together.

 

After we set up table in excel, you will be able to select ‘table’ which is detected by flow automatically.

v-duann-msft_1-1617344836377.png

 

For ‘key column’ and ‘key value’, they are used for identify unique value from your excel.

 

Key Column: It can be whatever column you want in a table that can serve as a reference to indicate what is the row that will be modified. Make sure that it has unique values, because an error will be generated if duplicate values in this column are generated.

Key Value: It is whatever unique value you want in the Key Column to indicate what is the row that you want to update.

Example: If you have a table with two columns: Column1 and Column2 and Column1 has numbers from 1 to 5 and you want to update the row that contains a value of 2 in Column1, then "Column1" is your Key Column and the value "2" (without the quotes) becomes your Key Value.

 

If you still have trouble building a flow, just explain me your requirement including 'information format in excel'/'information wants to be sent via email', I can help you or provide some tips for you.

 

Hope the content above may help you.

 

Best regards,

Anna

Anonymous
Not applicable

Hi Anna

 

Thank you for your kind and detailed reply. It was so helpful that I figured out what confused me.

 

Thanks!

Anonymous
Not applicable

Hi Anna

 

Thank you for your kind and detailed reply. It was so helpful that I figured out what confused me.

 

Thanks!

Hi @v-duann-msft .

What steps to add while creating a 'send an email to' action?

I am creating the same flow.

It worked, but the mail which I am getting after triggering the flow is not opening.

Below I have attached screenshot of what things I added in that action.

Sanket7030_0-1632466345631.png

Sanket7030_1-1632466369634.png

I am not sure about what to add in the 'Attachments Content'.

In my case I added 'Power BI data' into it.

 

Any help would be appreciated.

 

Regards,

Sanket Bhagwat

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,614)