Yes but can only give general (specific though) steps without seeing the email to tell you how to get the actually data "perfectly" out. And I do not know what "summarization" means.
In here, regardless of technical prowess, what you want done you should be able to describe in detail steps (like you would for any business process) so we can map the steps from the technical side to that, + pictures when you ask us to .. I am not even sure what you want you just showed things like ID: but didn't say what you want done with it.
1. You can create an automated Trigger that specifically points to your Inbox and is filtered based on the Email Address as you said its the same
If there are keywords in the Subject you can filter on that
2. Next you would use the Convert HTML to Text to turn the Body into Text
3. Parse the text for each value you want to get out, so you might end up with 8 Compose actions that use Split to grab the proper Name/Value or Key/Value pair out
4. I do not know what you want to do with this information but you can create a SharePoint list to capture each piece from each email, I would NOT recommend excel, please do not use Excel for it.
5. but you can use Create Item, to then write the data into SharePoint mapping your Key/value pairs to the list Columns
So essentially its
Trigger on a new email that meets my criteria
Turn the body into Text
Use Compose actions with a variation of multiple splits to get the Key/Value out
Now write the data into SharePoint
That's what I would do if you are asking what I am assuming.
If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.
Thank you!
Sincerely, Michael Gernaey
