Given that it is not clear if and when we will ever have the direct capability of retrieving data from SQL Server views into PowerApps, there must be a way of working around by using a combination of Auzre functions and custom APIs.
Has anyone managed? If so, how? I am only looking to read the data and not write.
It is possible, one guy did it for me. He did most on the SQL side, by collecting desired info into from a table to some kind of middle phase (a new 'ghost' table?!) on SQL side, then opened a 'Data Connector Gun' gateway between powerapps and SQL. No need of Azure.
Thanks for the reply. But how does the data in the 'ghost table' get updated?
Is it updated regularly (i.e. every few hours/days) or do you have to trigger the update? If you have to trigger the update, how is done?
SQL have some kind of functionality called View where Gun Connecter see's it and pulls the data.
We've been working with SQL - PowerApps and there are many restrictions. Like as you cannot specify latest objects to collect as SQL datatype format 'Date' is not supported by PowerApps own date format. And you can only collect max 2048 objects, which seems to be hardcoded by PowerApps. Very frustating.
To get a start with Node (API), it is compulsory to install node.js which is an open source runtime environment. It never blocks the task which is meant for providing asynchronous programming. Microsoft Professional Support
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand