@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