Forum Discussion
Alternatives for Excel as GUI for data collection
Microsoft Lists (SharePoint lists) are great for this. If you give your users contribute access, they will be able to enter data but not change column settings (this is what tends to break Excel sources).
With Power Apps, it's not necessarily an either-or, you can use Power Apps with lists if you want to - it's mostly about how much data you have and how complex it is. If you're working with millions of rows of data with relationship tables, make an app on Dataverse or SQL - note that this triggers premium Power Apps licensing for all app users, which can get pricey.
The setup and maintenance of MS Lists is MUCH lower, and the user experience for entering data is quite good. Power Apps you will have to put in a lot of dev time to match the user experience of lists, and it's more expensive, but it's better for more complex data and larger data sourcecs.
Microsoft Lists (SharePoint lists) are great for this. If you give your users contribute access, they will be able to enter data but not change column settings (this is what tends to break Excel sources).
With Power Apps, it's not necessarily an either-or, you can use Power Apps with lists if you want to - it's mostly about how much data you have and how complex it is. If you're working with millions of rows of data with relationship tables, make an app on Dataverse or SQL - note that this triggers premium Power Apps licensing for all app users, which can get pricey.
The setup and maintenance of MS Lists is MUCH lower, and the user experience for entering data is quite good. Power Apps you will have to put in a lot of dev time to match the user experience of lists, and it's more expensive, but it's better for more complex data and larger data sourcecs.