I work in an environment where SharePoint and Dataverse are not available; all we have is OneDrive for Business. I have multiple users who are using a standardized Excel workbook to track their work pipeline. For privacy reasons, we do not use a single, centralized workbook; each user has a copy of the workbook in their OneDrive. A common complaint has been that entering data in a spreadsheet is tedious and not user friendly.
I have created a Power App for data entry to alleviate the complaints. My question is, how can I make it so that when a user starts up Power App it opens and posts data to the Excel file on that individual user's OneDrive account? Having all the users keep their own copy of the Excel file in a standardized location (i.e. C:\Users\userid\OneDrive - Business\Desktop\PowerAppFile) wouldn't be a problem, but can Power App be dynamically pointed to the directory for the user by the userid? The Excel files all have the same table names, so the userid would be the only differentiator.
If that's not possible, what would be the best way to roll this app out to each individual and make it as easy as possible for them to connect to their own Excel tables? If I have to roll it out by giving each user a copy of the Power App, will there be any way to push out updates from a single file update, or will I have to resend them all copies again and deal with reconnecting the Excel file each time?
I am new to Power App, so I appreciate any guidance you can offer.
Jim
