Send an email for same alert for multiple legal entities

(2) Share

Report

Posted on by udaY-ch

5,180

Hi Folks,

I need to send email alerts to the purchase order creator when a workflow stops across legal entities. I set up an alert for one legal entity, which triggers a business event and Power Automate flow to send an email successfully and it works perfectly good.

The issue is when eabling the alert for organization-wide disables send externally which prevents business event triggers. Creating separate alerts and flows per legal entity causes duplicate emails since PO numbers share same number sequences across entities (some cases) if not the flow fails.

Has anyone encountered this? Any suggestions would be highly appeciated.

Thanks

Uday

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Diego Mancassola 902 on at

Like (0)

Report
Copy link

Link copied!

Hi Uday, one effective approach is to aggregate and deduplicate the events in a Dataverse table than sending the email.

In practice, the Business Event / alert always writes a record into a custom Dataverse table using a composite key, for example: DataAreaId, Creatorm, PurchId

At the end you can create a recurrency flow that send the email without duplicates of records not yet sended (using a state flag).

Best regards,
Diego

1 people found this reply helpful.

Was this reply helpful? Yes No
udaY-ch 5,180 on at

Like (0)

Report
Copy link

Link copied!

Hi Deigo

Thank you for your response, I thought so but thought there could be another way to solve this scenario. Here is what I wish to do, Create an entity for sysworkflowtrackingtable and expose to dataverse and trigger the flow upon recod modification especially the status of the table.

Thanks

Uday

Was this reply helpful? Yes No
André Arnaud de Cal... 305,643 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Uday,

Can you tell what table is used for the alert?

Was this reply helpful? Yes No
udaY-ch 5,180 on at

Like (1)

Report
Copy link

Link copied!

Hi @André Arnaud de Calavon

The use case is to alert and notify Purchase Order creator if their workflow instance goes to 'Stopped' state. To achieve I have decided to monitor the WorkflowTrackingStatusTable and triggering an alert when the Status field is updated to Stopped.

Thanks

Uday

Was this reply helpful? Yes No