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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Bringing Components of...
Power Automate
Unanswered

Bringing Components of an Email into Different Fields of a Sharepoint List

(0) ShareShare
ReportReport
Posted on by

We receive an automated email from our fleet management company when a certain type of driving event occurs.  The email is automated and the subject and body are formatted similarly for each occurrence.  Any thoughts on how I can strip out certain fields from the subject line and or body of the email to create a new item in a SharePoint list.  I know how to create an item just with the whole email, but I need to be able to create certain fields and create a Flow from there.

Categories:
  • Jay-Encodian Profile Picture
    2,920 on at

    Hey @jeffnelson10 

    This would work for the body of the email - https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Extract-data-from-documents-with-Microsoft-Flow/ba-p/370422

    It'd also be worth reviewing the AI builder approach as well.

    For the Subject; If the subject users a common structure you could use the 'Split' expression of string related functions to extract relevant data... this might also work for the email body, as you could use the 'HTML to Text' action to remove all the HTML mark-up leaving you with a string which you might be able to reliably extract data from.

    If you need more help it'd be worth adding some sample data for the community to review and comment on 🙂

    HTH

    Jay

    -------------------------------------------------------------------------

    If I have answered your question, please mark your post as Solved.

    If you like my response, please give it a Thumbs Up

     

     

  • v-litu-msft Profile Picture
    Microsoft Employee on at

    Hi @jeffnelson10,

     

    Could you please share an instance of the Email? (Please block the personal information) 

     

    Best Regards,
    Community Support Team _ Lin Tu
    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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 414

#2
11manish Profile Picture

11manish 331 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard