So far I haven't found anything similar enough to help me.
What I'm trying:
I want automate to check the triggering emails subject line against the group name on the sharepoint list/excel sheet, and forward the entire email to the corresponding email address in the sharepoint list/excel sheet. The subject of the email will always be 4 digits and should match one of the 4 digit numbers in the list/sheet.
Incoming Email Subject= #### (group name is 4 digit number)
Sharepoint list/Excel Sheet:
| Group Name | Leaders Email |
| 1111 | jdoe@email.com |
| 1234 | pparker@email.com |
| 2234 | mwatson@email.com |
| 4444 | nstark@email.com |
I'm struggling to find an expression using dynamic content that works. I'm a beginner to power automate, though I understand the basic foundations of how it works.
Background:
I'm doing a survey for subgroups within my organization, and I want to automatically forward responses for each subgroup to the subgroup leader. The survey program from our website does not integrate directly with power automate, but it will send an email with the subgroup name as the subject line. I have a sharepoint list and excel sheet with each subgroup name and the leader for that groups email. The surveys are set to go to an outlook folder that will only be used for the surveys.
I'm a basic user of power automate, I'm learning how to use expressions with dynamic content.
