How do I use Power Automate to pull data from the body of an email and import to excel?

Question

Please help.. Here is what I want to create in power automate, but I can't find an answer: Please give step by step.

1.) The information I want to extract is from the same sender every time. The email contains the same categories each time - Here are the categories below. Each of those categories are going to have text next to it.

I want to take the text that appears next to each category (from the body of the email) and have it put that data into the different rows that I made in my spreadsheet. I attached an image of the spreadsheet.

Secondly a "RIT#" appears in the subject line of each of these emails, I would also like that to be imported into the "RITM#" Column in the spreadsheet.

Class
Faculty Member/Instructor
Date and Time
Recording Type
Requestor
Reason for Recording
Additional Information

Answer 1

Dear Mystery,

Thank you for posting this question in Microsoft Community.

Since our category focus on general troubleshooting and built-in features in Outlook, and we have a dedicated Power-Automate channel Microsoft Power Automate Community - Power Platform Community related queries. For you to be assisted properly, we sincerely recommend you go to that community and post a new thread. You can click "Start a Topic" to post a question there.

Thanks for your patience and understanding. Have a good day!!

Best Regards,

Answer 2

Hi - sorry i did actually

https://powerusers.microsoft.com/t5/General-Power-Automate/How-do-I-use-Power-Automate-to-pull-data-from-the-body-of-an/m-p/2299689