I'm new to power apps here and I've been assigned an automation task that I'm trying to solve.
So my company uses a poweapps application to store data in an azure database. There is this form where the revenue per client and per month/year is entered manually and submitted to the database.
Meanwhile the company disposes of a Sharepoint excel file where there's so much data/sheets including a specific table of clients in rows, month/year in columns and revenues in cells.
So each time a revenue is stored in the database by a user A, it has to be stored in the excel file as well by a user B.
So I've been asked to automate this process, and synchronise the revenue from power apps to the excel file in Sharepoint. Once user A submits the form, the new value must be stored in the database and the excel file as well.