cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Coming Soon: T-shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors
Users online (6,432)