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 / Retrieve the Document ...
Power Automate
Unanswered

Retrieve the Document and change the SharePoint List item's choice value from an email Information.

(0) ShareShare
ReportReport
Posted on by

Hi Guys,

 

I am running a flow where the sales department will send me an email when a transaction is finished with a client. This email has a document related to the bank statement and some information related to the transaction in the email. I wonder how can I design a flow where it detects the email header value ( or other recommendation ) that may match the unique transaction code value in a SharePoint List and then changes the item's choice value from a SharePoint list and puts the attachment in that item. 

 

Really appreciate.

 

Categories:
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    @sam123123123 

     

    Are you able to share a sample email. You should be able to extract the text using string manipulation techniques.

     

  • Michael E. Gernaey Profile Picture
    53,975 Super User 2026 Season 2 on at

    @sam123123123 

     

    As @SudeepGhatakNZ  mentioned it would be good to see a mock up of the email. I don't think using a header would do anything, unless you are certain that the sales people know how to add custom values to headers

     

    Also you don't mention, but are you looking for this to be a triggered flow?

     

    If so it would have to check every email that you get, which would be a ton and use up precious actions on your monthly bill cycle. I would create a share mailbox or at least another email that is dedicated to just receiving these emails from the sales people, so that you aren't firing off every time you receive an email

     

    Pre-Step Suggestions

    1. I would ask the sales people to put the Id etc in the subject

    Subject: Email for Sale XYZLSF or whatever

    Then you can simply parse the Subject versus the body

     

    2. Or have them put that in the body of the email anywhere, but ask them to follow a specific format like

    SalesId: asdfasdfasdf 

     

     

    Pseudo Steps

    1. When an Email Arrives

    2. Use the Html to Text action to transform the Body into Text

    2a. You will also need at some point to use the get attachments action

    3. Add a Compose action that will search for your string value and also grab the id, and how you do it will depend on how you implement so I cannot give you 100% answer

    4. Now use Get Items to filter and find the Item (row) you want in the list

    5. Now use the Get attachments to attach the Document to the item from step 4

    6. Use an Update Item to update the item from step 4

     

    Another suggestion would be to create a simple Canas App, that they can populate with the Id, item etc that would trigger the Flow to do the work

     

    Or just create the App that connects them directly to the SharePoint list, let them find the transaction in the list if it exists using the Id you mentioned and save it and done.


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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
11manish Profile Picture

11manish 307 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 127

Last 30 days Overall leaderboard