cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MiaFoods
Level: Power Up

Grouping parsed data

Hello,

I want to begin processing email orders automatically. Currently we rewrite email orders by hand and process them onto pick sheets.

My initial plan was to use a mail parser to extract the data to a OneNote document with the customer name and items ordered. Ideally, I'd want the page as full as possible, with orders going across the page and down from left to right in rows

Our orders are then sorted into groups that are defined geographically, about a 90% similarity from day to day. This task is currently done manually, and we would like to automate it. Is this a possibility with Flow?
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Grouping parsed data

Hi @MiaFoods ,

 

You could consider saving the data from the received email to excel table or sharepoint list. 

Please take a try to achieve your requirements with microsoft flow and it could be easy and convenient.

https://asia.flow.microsoft.com/en-us/

You could refer to link below to learn more about the microsoft flow:

https://docs.microsoft.com/en-us/flow/

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

2 REPLIES 2
rogrimbe
Level: Powered On

Re: Grouping parsed data

Hi MiaFoods,

 

specificlly with OneNote it is a bit of an issue to update an existing document 

but if you replace it with excel which also sounds like the best options for you

it is very easy because you have an aciton add row into a table. 

so if the parsing part is not the issue and the email comes in a template then you can run a trigger incoming email. 

parse it with condition and add rows to excel with the data you want

Highlighted
Community Support Team
Community Support Team

Re: Grouping parsed data

Hi @MiaFoods ,

 

You could consider saving the data from the received email to excel table or sharepoint list. 

Please take a try to achieve your requirements with microsoft flow and it could be easy and convenient.

https://asia.flow.microsoft.com/en-us/

You could refer to link below to learn more about the microsoft flow:

https://docs.microsoft.com/en-us/flow/

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

Helpful resources

Announcements
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 Kudoed Authors
Users Online
Currently online: 338 members 6,195 guests
Please welcome our newest community members: