Add new data source to powerapps through a flow or any other non manual way. And create a dynamic gallery by dropdown list.
I have been looking for a way to add a new data source to my power app when something is triggered. I am thinking about creating a button that when pressed triggers the creation of a SQL table on azure according to data passed by power apps, but I also want that new created table in the SQL database to be added as a new data source to the power app. Is there a way to trigger the connection of data sources to power apps?
I want to use this database table connection to create a dynamic visualization gallery which displays data source information according to the source selected in a dropdown list. I would have to add dynamically the new data source to the list.