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.
