Hi Grover,
I am familiar Power Apps. Unfortunately, I don't have the time to invest in the steep learning curve required to use it. As opposed to Access, I also find the Power Platform environment incredibly unwieldly and complicated. Developing and deploying apps using Access is much faster than Powers Apps. Access allows for the creation of queries and reports in one environment. And easily customizing a Power App? Good luck with that. Furthermore, the hybrid Power Apps environment, what I call pretzel logic, with confusing GUI's, makes it nearly impossible to create anything useful without deep programming experience. To be clear, I am not a software developer. I am an Access Database developer. And that is the huge difference here.
Access is a tool that citizen developers like me can use with a reasonable learning experience in a reasonable amount of time, something Microsoft is woefully out of touch with. Whoever developed Power Platform doesn't understand the exigencies of medium to small businesses or, in my case, a nonprofit. Busy, overloaded staff, i.e., citizen developers, need tools requiring minimal coding and learning time. Microsoft, touts Power Apps as a low code/ no code platform. Sure, you can create an app from a spreadsheet or an SP List and create something like an employee directory via drag and drop but the low code side is anything but! And this is why upwards to 75% of staff at organizations that have Power Platform licenses don't use the application. It is just too difficult to use. In this regard, Power Apps is not a very useful tool.
In any case, I found the solution I am looking for and, ironically but not surprisingly it, is not a Microsoft solution.