Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data entity for SysEma...
Finance | Project Operations, Human Resources, ...
Answered

Data entity for SysEmailHistory

(1) ShareShare
ReportReport
Posted on by HS-30050809-0 21
Hi, 
i want to to make a flow using the Fin&Ops flow in Power Automate to get SysEmailHistory from D365, but i cant find an entity or a way to export the data from D365. 
Does anyone have experience or knowledge on how to get data from TableBrowser?
I want to use the Email status to send a notifcation by mail, but cant access the field in Power Platform. 
  • HS-30050809-0 Profile Picture
    HS-30050809-0 21 on at
    Data entity for SysEmailHistory
    Thanks Anthony and Andreas for the answers.
     
    I think the best solution in my case is to create a custom business event.
     
    Really appreciate the help, and have a nice week! 

    Br. Herman Sanne-Halvorsen
  • Verified answer
    Anthony Blake Profile Picture
    Anthony Blake 2,201 Super User 2024 Season 2 on at
    Data entity for SysEmailHistory
    Great solution from Andreas, however if you want to avoid reliance on email when reporting email errors you could create a custom business event, there is a power automate connector:
     
  • Suggested answer
    AB-10051525-0 Profile Picture
    AB-10051525-0 7 on at
    Data entity for SysEmailHistory
    Wrote this using the wrong account 
  • Suggested answer
    andreasraithel Profile Picture
    andreasraithel 4,822 Super User 2024 Season 2 on at
    Data entity for SysEmailHistory
    Hy,
    you are right for the EMail processing there is no entity to get the sending history.
     
    But what you can do you can create "Alert rule" on the EMail history table for the case that the value of the "EMail status" of EMail "A" is set to a dedicated value like sent, failed, ... whatever you want.
    This can trigger to send a EMail B that the EMail A was sent.
    Unfortunately the "send externally" is not active for that Alert rule on this table. If this would be active you could capture the Alert also in the Power Platform and create any flow based on the triggered event
     
     
    Hope this helps.
     
    Herzliche Grüße / kind regards,
     
    Andreas Raithel
    D365FO Solution Architect
     

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans