Showing results for 
Search instead for 
Did you mean: 
New Member

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

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.

Super User
Super User

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.

Super User
Super User

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. 

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,196)