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 Platform Community / Forums / Power Automate / Extracting Tracking Nu...
Power Automate
Unanswered

Extracting Tracking Number and PO Number from the body of the email arrived and Storing them in excel spreadsheet.

(0) ShareShare
ReportReport
Posted on by

Hello Everyone,

 

I want to automate the process and want to build a flow. Whenever a mail is arrived I have to extract the Tracking # and PO# from the body of the mail and store that in  the excel sheet with same column number. It will be a great help if anyone assist me in this. Thank you in advance.

Categories:
I have the same question (0)
  • v-qiaqi@microsoft.com Profile Picture
    on at

    Hi @Anonymous,

    Show me your email body.

    Here is some similar threads for your reference:

    Solved: Re: Due date time in email body - Power Platform Community (microsoft.com)

    Solved: Re: Extract text from first line of email up to a ... - Power Platform Community (microsoft.com)

     

  • Community Power Platform Member Profile Picture
    on at

    Rohan11_0-1694614487601.png

    It reflects actual numbers in the output. I just dont know what all to insert in excel step.
    My email body is straight forward it is just a text and numbers ahead.

  • Community Power Platform Member Profile Picture
    on at

    What will come in Key Column and Key Value tab?

    Thank you in advance.

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard