This is a Power Automate solution that automates the sales process of whose payments are due in certain and serves as reminder to sales lead. The sales lead gets an email for for those customer whose balance are still arrears and the data is store within sharepoint
This is first Sample email notification result for Sales that would be due in the next 70 days
Flow overview
Fixed the status issue shown on the first screenshot, The Status now shows properly.