Power Platform Community Forum Thread Details

I am trying to create an automation to track emails that I send to a certain folder. The emails I move here are forwarded to me (which might cause an issue).

If the emails are forwarded to me, and I have the automation to add a row to a table in excel, is there a way to have it track what is said in the original email and not the forwarded message?

I also want it to pull information from already in the folder. Is there a way to make this run now, and then automatically update the table when I add a new one to the folder?

Categories:

Building flows

Hi,

See whether this helps !

1. Use send http request to use graph api to get list of email associated with conversation id

2. now the body dynmaic content would have emails associated with forwaded email (which is causing trigger )

Now use the select action to capture only the subject and body (you can add other properties if needed)

Expression used:

outputs('Send_an_HTTP_request')?['body/value']
 
3. Now use the compose action to remove duplicate emails content from select action
 
4. Use filter to remove emails from output of above compose action for the subject whose subject does not start with Fw:
 
Now use the below expression to get forwaded email (correct content)
 
Hope it helps !
 
Mark it as solution if it resolves your query !
 
Thanks & Regards,
Nived N