cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andrejker
Level: Powered On

flow- add row to excel when receive email

Hi,

I wanted to create Flow, to add new row to excel when new email is received (with specific receiver email). In the second step when I tried to add excel action I should enter "Table name" but I am not sure what this is. I entered Sheet name, which I thought this is, but it does not work. Any suggestion for beginers 🙂

 

Capture.PNG

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: flow- add row to excel when receive email

Hi @andrejker,

 

The table mentioned here does not indicate to the Sheet in Excel.

To connect to an Excel under Micrsooft Flow, we need first define a table under that Excel.

Create or delete an Excel table

Please follow the article below to rename the Table under Excel:

Rename an Excel Table

In addition, please check this blog as a reference:

Flow of the Week: Save tweets to Excel for data analysis

If you have any further questions, please feel free to post back.

Regards

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: flow- add row to excel when receive email

Hi @andrejker,

 

The table mentioned here does not indicate to the Sheet in Excel.

To connect to an Excel under Micrsooft Flow, we need first define a table under that Excel.

Create or delete an Excel table

Please follow the article below to rename the Table under Excel:

Rename an Excel Table

In addition, please check this blog as a reference:

Flow of the Week: Save tweets to Excel for data analysis

If you have any further questions, please feel free to post back.

Regards

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

andrejker
Level: Powered On

Re: flow- add row to excel when receive email

It worked and I was able to set it up. However in table I added only 3 columns. When flow inserted data it also aded 4th column with some code/reference. Any idea why and what this is?

 

Capture.PNG

Community Support Team
Community Support Team

Re: flow- add row to excel when receive email

Hi @andrejker,

 

The auto-generated column (PowerAppsID) is created by the connector, which is used to mark the rows for Microsoft Flow to perform requests with the Excel table, something similar to the Primary key under SQL table.

We'd better leave it where it is.

Regards

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,802)