I am not sure if this is the correct place for this but I am trying to use Power Apps for Teams to create an app that tracks some data for a team.
It seems straightforward to create tables that are stored in the Dataverse for Teams( Which I understand is not the same as Dataverse). However, I need the user to be able to choose data from a list where the data resides in an on premises SQL Server. We do have an on premises data gateway in place.
Is this possible using Power Apps for Teams (Which I understand is not the same as Power Apps)? If so, what is the best way to do it? Can Power Apps for Teams use the on premise table or view directly or is it better to create a table in Dataverse for Teams and periodically refresh the data in the table from the on premises database?