Power Automate: Error in AGING calculation when sending automated SOA

Question

I am creating a Power Automate flow to automatically send Statements of Account (SOA) to customers. The flow retrieves data from [Excel / SharePoint / Dynamics], calculates AGING for invoices, and sends the SOA via email.

The issue: The AGING calculation is incorrect or causing an error. Instead of showing the correct number of days past due, it returns [describe the wrong result or error message].

Steps I tried:

• Used Excel formula =TODAY()-DueDate
• Applied Power Automate expression addDays()

Expected result: Correct AGING values in the SOA email. Actual result: [describe what happens].

How can I fix the AGING calculation in Power Automate or Excel so the SOA sends correctly?

Answer 1

Dear @Nhica Panada,

Thank you for posting your question in the Microsoft Q&A forum and for sharing the details of your situation. I understand how important it is to ensure accurate aging calculations and avoid errors when sending notifications in your Power Automate flow. 

As our current forum primarily supports Microsoft 365 products, and your issue relates specifically to Power Automate (Microsoft Flow), we recommend posting your question in the Microsoft Power Automate Community for expert assistance. The reason I ask you to post a new topic is that in the Answers forum, we have limited resources and very little knowledge about Power Automate, and in Microsoft Power Platform Community Forum Thread, you'll get the most qualified group of respondents, and other partners who read the forums regularly can share their knowledge or learn from your interaction.    

The reason for this redirection is to ensure you receive the most qualified support and avoid any incorrect information. Members of that forum, including Microsoft experts and partners, regularly share solutions and best practices for scenarios like yours. 

We truly appreciate you're understanding and wish you success in resolving this issue quickly. If you need help navigating the community or structuring your question, please let us know, we’re happy to assist. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.