cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kj1
Level: Powered On

Flow to extract text from email and create item

Hey all!

 

I have this problem and am VERY new to flows... so take it easy it on me.

 

I recieve a number of emails throughout the week which come from field agents for failed equipment. I need to extract specific information, but the length of the requests vary alot. I will paste an example, but basically, I need to get the highlighted cells for sure and then assign a due date (it will be by 4pm every day into a sharepoint item. I have seen posts that do some of what I need, but I have not been able to piece it all together. I can get the email and body, and create the right item type, but cannot figure out how to extract the info properly.

 

 ***** ** * *** Equipment Failure Form - Store: *****

Submitted by: name@domain.com   

Tech Number: ********

Contact Number: *10 digit number here*   

Store Number: *5 digit store number*

Type of Problem: Failed   

Equipment Type: New   

******** Equipment Failure: *lines of text here*   

Serial Number: *line of text and number here*   

Equipment Description: *lines of text here*  

Equipment Location: *lines of text here*   

Problem Description: "lines of text here*   

Ship To: store 

Service Type: *lines of text here*  

Comments: *lines of text here*     

 

ALL REPLACEMENT HARDWARE SHOULD BE RETURNED TO *******: TAGGED WITH THE STORE NUMBER

 

1 ACCEPTED SOLUTION

Accepted Solutions
swhitmore
Level: Powered On

Re: Flow to extract text from email and create item

1 REPLY 1
swhitmore
Level: Powered On

Re: Flow to extract text from email and create item

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: 309 members 6,425 guests
Please welcome our newest community members: