I am going to collect payment for multiple invoices via a single payment instrument/cheque.
Customer ID : 1, had total 5 nos. of Invoice
( Invoice ID: 1; Due Amount: 20000;
Invoice ID: 2; Due Amount: 50000;
Invoice ID: 3; Due Amount: 30000;)
The total of all Invoice Due Amounts is 100000.
Now customer paid me issuing single instrument/cheque amount is 100000/-
Instead of updating individual invoices manually, I want it to get updated automatically when I put the received amount in TEXT_INPUT in PowerApps.