Forum Discussion
Which tool is right for me? (Powerapps, Sharepoint List Form, Excel Survey, etc)
I have a couple of projects I'm working on right now where I need a simple form to collect data from users. We have O365 E1 so lots of tools are available to us, but I'm not sure which one is t...
There's no silver bullet here - each has pros and cons, and each comes with their own level of complexity.
I would however suggest that using a SharePoint list you have a better level of data access and integration with other services, whereas anything collected in Excel lives inside the file and is an extra step to retrieve / integrate.
PowerApps you only need to do if you want a desktop or mobile based app for the end user.
I would start with a SharePoint list, wrap a Flow about it, and then decide how you want the front end to look like - whether continue using the SharePoint list entry form or take it a step further.
I would however suggest that using a SharePoint list you have a better level of data access and integration with other services, whereas anything collected in Excel lives inside the file and is an extra step to retrieve / integrate.
PowerApps you only need to do if you want a desktop or mobile based app for the end user.
I would start with a SharePoint list, wrap a Flow about it, and then decide how you want the front end to look like - whether continue using the SharePoint list entry form or take it a step further.