I'm looking to automate the process of updating invoices payment status to "paid" and entering the date paid on SharePoint. Every day I receive an excel file with a list of newly paid invoices and am tasked with going into SharePoint, filtering for the specific vendor, and updating the information accordingly. It is a very time consuming task, and I know there must be a way to automate the process.
I've attached images of what the excel file and sharepoint page look like.

Report
All responses (
Answers (