
Hello There,
I am trying to figure out how to find specific predefined list of keywords in the subject and body of email.
So my flow is:
1. Triggered - when an email is received.
2. get profile of user
3. Convert email body to html
4. Condition - if .... output html text (body of email) contains a,b,c,d, then add a row to excel table as follows
| Date | From | From Department | Request type | document type | Internal or external | Priority |
| This field should fetch date of email | This field should fetch sender of email | This field should fetch department of sender of email. | If the subject or body of email contains keyword 'a' then this field should be set as "Request for 'a' ".
If the subject or body of email contains keyword 'b' then this field should be set as "Request for 'b' ". | This field should be set as the identified keyword. For ex. 'a' or 'b' or 'c' or 'd' | If the department of sender is not x, the set it as 'outside' | if the email is flagged - set as urgent else not urgent. |
I am trying to figure out how to write the conditions to fetch and add the correct data. Consequently, create a flow accordingly.
Any support or idea is appreciated.Very new to power automate. everything I tried is based on reading and trying out ideas based on previous articles and solutions.