Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Email Tracker Automation

Posted on by
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?
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 16,559 on at
    Email Tracker Automation
    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
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard