I need to create a Power Automate flow to automatically process records from two related tables in the Dynamics 365 F&O system. The flow should filter records based on a shared key, sum values from the first table using that key, and then compare these summed results against values in the second table. If the sum is less than the specified value in the first table, the flow should send an email alert. The sum value will vary based on system transactions.
Please, I need someone to assist me to move on with this flow and writing the step-by-step necessary queries to achieve the goal, since I am a beginner in the power automate language.
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.
2
Share
Report
All responses (
Answers (
