How to Import Email to Excel using Power Automate - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Peter
I'd like to see the flow for getting email attachments (which conform to certain criteria) from Outlook to Excel. Each week i get an email from same customer address with a zip file (always same name) It contains two.csv files (again always the same two names). I only want one of those, and I want it to automatically replace the previous week's version in the folder I specify. Right now I have to open the zip, accept the warning, drag the file manually to a folder, accept another warning, then confirm I want to Copy & replace: then finally I can use PowerQuery to extract the data I want from the .csv It's a mahoosive file when it's extracted from the zip, over 20Mb so it all akes a while. An automated process would be great.
reply
I'd like to see the flow for getting email attachments (which conform to certain criteria) from Outlook to Excel. Each week i get an email from same customer address with a zip file (always same name) It contains two.csv files (again always the same two names). I only want one of those, and I want it to automatically replace the previous week's version in the folder I specify. Right now I have to open the zip, accept the warning, drag the file manually to a folder, accept another warning, then confirm I want to Copy & replace: then finally I can use PowerQuery to extract the data I want from the .csv It's a mahoosive file when it's extracted from the zip, over 20Mb so it all akes a while. An automated process would be great.
reply
Hari
Hi Kevin, this was indeed very useful! Thanks a LOT! I am trying to automate a process and wonder if you may have some ideas on this. I have an Excel file with project data piled and compiled from different systems. However not all projects are in the systems. So for some of them I need to collect the missing data. Now I can ask the project managers to go into the file and complete it but it would be much cooler if I can automatically send the missing fields to them via Email or form and ask them to send back the missing data and incorporate it in the sheet . Do you think there may be a way to do this with power automate? Thanks and keep the great work!
reply
Hi Kevin, this was indeed very useful! Thanks a LOT! I am trying to automate a process and wonder if you may have some ideas on this. I have an Excel file with project data piled and compiled from different systems. However not all projects are in the systems. So for some of them I need to collect the missing data. Now I can ask the project managers to go into the file and complete it but it would be much cooler if I can automatically send the missing fields to them via Email or form and ask them to send back the missing data and incorporate it in the sheet . Do you think there may be a way to do this with power automate? Thanks and keep the great work!
reply
Aleph
Totally confused by the expressions used in the video. For instance, the first one specifies -Quantity- not -Cookie Type.- The next line shows -Delivery Method- and then -Quantity-. The last line shows -Quantity- again. This is confusing. I have tried to run just one expression, and the only think that I can see is that lines were added to my excel sheet. No text information at all. Can someone please help me understand what I am missing here. I am trying to extract 21 fields from the body of emails that are sent to me concerning families requesting toys 4 tots. I can't even get it just to populate the name field to begin with.
reply
Totally confused by the expressions used in the video. For instance, the first one specifies -Quantity- not -Cookie Type.- The next line shows -Delivery Method- and then -Quantity-. The last line shows -Quantity- again. This is confusing. I have tried to run just one expression, and the only think that I can see is that lines were added to my excel sheet. No text information at all. Can someone please help me understand what I am missing here. I am trying to extract 21 fields from the body of emails that are sent to me concerning families requesting toys 4 tots. I can't even get it just to populate the name field to begin with.
reply
Jennifer
Kevin - will this only work with columns? I'm trying it with rows and it only shows the 1 column after I click on Add a Row Into a Table. Also, does this work with Egnyte instead of One Drive? And, I'm working with an Excel Worksheet that has 4 different tabs. Is there a way to specify which tab the information needs to be entered into? I would assume the email subject would need to be different for each separate tab.?? Thank you
reply
Kevin - will this only work with columns? I'm trying it with rows and it only shows the 1 column after I click on Add a Row Into a Table. Also, does this work with Egnyte instead of One Drive? And, I'm working with an Excel Worksheet that has 4 different tabs. Is there a way to specify which tab the information needs to be entered into? I would assume the email subject would need to be different for each separate tab.?? Thank you
reply
Kathryn
Would love to see video how to mail merge several collated rows of data from excel. I have 177 students, each student has 4 rows of student peer feedback scoring and comments imported from MSForms. Trying to figure out how to grab 4 rows of data per student, collate it, and send out a single email to each student with their specific rows of feedback. I can send out 4 emails, but they hate email!
reply
Would love to see video how to mail merge several collated rows of data from excel. I have 177 students, each student has 4 rows of student peer feedback scoring and comments imported from MSForms. Trying to figure out how to grab 4 rows of data per student, collate it, and send out a single email to each student with their specific rows of feedback. I can send out 4 emails, but they hate email!
reply
Ola
Hey how do I indicate in the expression that my answers and under the question. I get emails from survey that looks like this (example of the question)
3. Please Seelect Your Country
United States
And the flow works however I get in the right cell word response, it look like the expression doesnt pick up the answer becuase it is in below row.
How do I change that?
Thank You!!!!
reply
Hey how do I indicate in the expression that my answers and under the question. I get emails from survey that looks like this (example of the question)
3. Please Seelect Your Country
United States
And the flow works however I get in the right cell word response, it look like the expression doesnt pick up the answer becuase it is in below row.
How do I change that?
Thank You!!!!
reply
Great
Kevin, suggestion for a future video (if you know a solution)... When copying a table from Excel and pasting into Outlook the resulting table columns are too narrow in Outlook. Any idea why, or how to avoid this issue (without manually resizing them)? I would expect a perfect copy/paste since both programs are Microsoft, but I always end up having to resize the columns.
reply
Kevin, suggestion for a future video (if you know a solution)... When copying a table from Excel and pasting into Outlook the resulting table columns are too narrow in Outlook. Any idea why, or how to avoid this issue (without manually resizing them)? I would expect a perfect copy/paste since both programs are Microsoft, but I always end up having to resize the columns.
reply
orfeous
I want to export Name and From inbox mails and also from sent mails to CSV-file and then import them as contacts in outlook. Possible?
Now i only have like a cache in outlook. When i type a name their mail shows up.. since i mailed them before or recieved mail from them.. but not saved as a contact.
reply
I want to export Name and From inbox mails and also from sent mails to CSV-file and then import them as contacts in outlook. Possible?
Now i only have like a cache in outlook. When i type a name their mail shows up.. since i mailed them before or recieved mail from them.. but not saved as a contact.
reply
Hashmi
Thanks Kevin, very usefull.
I want to filter the extraction from email i.e I want to only add/extract rows having cookie type A, how can we add filter extraction on email text in the power automate. I tried filter expression but I am finding difficulty in making it work.
reply
Thanks Kevin, very usefull.
I want to filter the extraction from email i.e I want to only add/extract rows having cookie type A, how can we add filter extraction on email text in the power automate. I tried filter expression but I am finding difficulty in making it work.
reply
DS316316
Hi, Kevin (or anyone else who got this to work!!!). How does one get Outlook's Received Time Field to appear in Excel in date format? Mine looks like this:
2022-02-27T21:17:10+00:00. Not only is it GMT (not my time zone), but it doesn't have a normal date format.
reply
Hi, Kevin (or anyone else who got this to work!!!). How does one get Outlook's Received Time Field to appear in Excel in date format? Mine looks like this:
2022-02-27T21:17:10+00:00. Not only is it GMT (not my time zone), but it doesn't have a normal date format.
reply
Add a review, comment
Other channel videos
3:31