
Announcements
Hello, I was wondering if is there any possible way to display the result of a sql query on a datatable. Many thanks!!
Hi @ogarrii
There are a couple of ways to do this.
If you can express your SQL Query in a way that you can define in a SQL View, you can create a SQL View that contains the query. You can then add this view to your Power App and set the Item property of the data table to the view.
Alternatively, you can create a Flow that executes the query. You can call the Flow from Power Apps and populate a collection with the return value. You can then set the Items property of the data table to the collection.