web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Answered

Grouping parsed data

(0) ShareShare
ReportReport
Posted on by
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?
Categories:
I have the same question (0)
  • rogrimbe Profile Picture
    on at

    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

  • Verified answer
    v-alzhan-msft Profile Picture
    on at

    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#3
David_MA Profile Picture

David_MA 270 Super User 2025 Season 2

Last 30 days Overall leaderboard