I have a customer who wants to remove manual data entry in spreadsheets. He has a daily monotonous task of manually entering bank reconciliation transactions from his bank account into his accounting system He knew this was a waste of his time and asked me if I could come up with a solution to automate this procedure.
Indeed, I could by using Power automate.
The customer provided me with
2 – A sample of the CSV file of the receipts that the bank provides on a daily basis.
This is the how I removed manual data entry using Power Automate.
Then create an “Apply Each” Loop to read through the array and grab each column
Then within the loop populated the spreadsheet with he matching variables.
This flow has given my client the ability to remove manual entry in Spreadsheets.