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

Error Creating Flow Outlook To Excel

Hi all,

 

I am new to Microsoft Flow,

I am trying to create a Flow to log all sent email to an Excel file on my laptop

I believe I walked through the steps correctly where my file is C:\Data\Email.xlsx and I have a 1x1 Table named tblData.

 

Is it possible with a local file?

Or do I have to use a SharePoint List?

 

Thanks.

6 REPLIES 6
yashag2255
Dual Super User II
Dual Super User II

Hi @Anonymous , 

 

You cannot do operations with flow on a static Excel file stored on your physical machine. You will have to use Excel Online, Excel on onedrive, sharepoint or dropbox for that. pps.png

Image and URL are the columns in my table "Table1" in the excel sheet "Book1" stored in the onedrive document library. 

 

Hope this helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

Thanks yashag2255,

 

I added a List to my SharePoint. Do I aneed to add any Columns to the List? Or will the Flow take care of it?

 

Thanks,

-w

Hi @Anonymous , 

 

On the sharepoint list, you will have to create the columns for the data that you are trying to log. 

 

For example, if you are trying to store the from email address, subject and body then you will have to create three columns one for each. 

 

Hope this Helps!

Thanks

Anonymous
Not applicable

Thanks yashag2255,

 

I ended up creating a workbook in OneDrive with a Table named Table1

Do I also need to add as many columns to this Table as # of columns I want to log?

Do the header names need to be anything specific?

 

Thanks,

-w

Hi @Anonymous , 

 

Using one drive is a pretty good option.

Note: In the excel on notebook, select the cells and click on format as table. If there is no other table on the excel, this will be named as Table1 by default. While formatting as table, it will ask if it has headers, so click Yes. And what all information you want to log (e.g., From, Subject and Body) should have a header. So for this, you select three columns and format as table and change the column names. 

 

In flow, create the action as insert a row in table and it will ask you to selct the excel file and table etc. choose those and then youcan see the columns you created. reference the relevant data to th columns and it should work then. 

 

Hope this helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Hi @Anonymous ,

 

The method provided by @yashag2255 can basically cover your needs, please take a try.

It's also worth noting that Excel Online connector only supports operations on files stored in SharePoint/OneDrive for Business/ OneDrive for Personal currently, not include Dropbox.

 

Best Regards,

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

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (74,074)