Hi BCS,
Based on your requirements, a combination of Power Apps and SharePoint Lists or Dataverse could be a suitable solution. Here’s a comparison of the two options:
- Power Apps with SharePoint Lists:
- Easier to set up and manage.
- Lower cost compared to using Dataverse.
- Can import a choice column from SQL using Power Query in Power BI or using a custom API connection in Power Apps (though it might be a bit more complex than using Dataverse).
- Suitable for small to medium-sized datasets.
- Power Apps with Dataverse:
- More robust and scalable, suitable for larger datasets and more complex applications.
- Better integration with other Microsoft services like Power Automate and Azure Functions.
- Direct querying of SQL data sources is more straightforward.
- Higher cost compared to using SharePoint Lists.
Given that your requirements seem relatively simple, using Power Apps with SharePoint Lists could be a good starting point. If you find that you need more advanced features or better integration with other services, you can consider migrating to Dataverse later on.