Is it possible to replace a tool I was using in MS Access with Power Apps?

[msdana803]

I used to have a shopping list tool in MS Access for personal use. It had a few tables, a query for updating some checkboxes, and reports for clearing checkboxes and printing the shopping list based on store.  The db is so old, I wasn't going to try to restore it. I just want to recreate something new without MS Access.  I figure I can use Azure SQL to store the tables (or can Power Apps store data?), and maybe Power Apps to  create a form to edit data, then is there a way to do reports too with a parameter to specify, or do i have to create a report in yet another tool like power bi?  MS Access was pretty awesome. It's a challenge trying to recreate something new that can do the same thing using today's new tools.  I don't know much about power apps yet.  There is tons of training and learning (hours and hours and hours I have access to), but I want to make sure i focus on the parts needed to do what I want since I don't have much personal time to work on it. So, for someone who's very familiar with Power Apps and doing some of what I just mentioned, what tools or features of Power Apps and Azure should I focus on to potentially recreate my little shopping tool? I figure it's a good way to learn something and apply it.  I also need it to be simple enough to use so that my husband can access it and edit and print without needing to know all the technical details.  Thanks!  I'm just overwhelmed by all the terms of power apps that i don't even know what i need to go learn.  Such as dataverse, canvas apps, etc, not knowing if any of these would be applicable to what i'm trying to do.

[WarrenBelz]

Hi @msdana803 ,

I am not sure how to respond to all of those questions, but I can tell you I have replaced a substantial MS Access system completely with Power Apps running on SharePoint. I have a blog site (the first articles in particular) that may be helpful in getting you started.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[TheRobRush]

To echo Warren, you can do most anything you can imagine in PowerApps. I would recommend you start with canvas apps, spend some time playing and learning. If you really want to PowerApps CAN technically store all the data within itself via collections, and editing of collections then saving those on your device locally and reloading them every time you open the app. Though, this is unnecessary, for someone new to the program I would recommend utilizing SharePoint as your datasource. 

[keithpresley365]

Hi,

Looking to migrate several MS Access applications (containing VBA code) all using the same database on an SQL server via linked tables.
These application also have a number of designed reports, including some that are invoices for customers.

The applications are used for Goods In and job creation for them, process flow/control and auditing during the jobs life cycle, as well as dispatch, stock control, along with pricing and invoicing.  

Was looking to migrate the reports to Power BI and the forms with their VBA functionality to Power Apps, connecting to the existing SQL Server we host on site. 

Of course, it would be great, if there was a way of exporting from Access and importing to Power BI, all the reports and their design, without having to recreate them from scratch in Power BI

Any advice, suggestions or pointers would be appreciate, as well as training literature and video, for a SQL/VB.net developer new to Power BI and Power Apps.

Regards,

Keith.