Is there a way to use View from SQL Azure Database??

[Sidhartha75]

Hi Friends,

Can anybody please help in consumjng views in PowerApps??

My data source is Azure SQL Datatabse. I have two tables Aseets and Sites. Below are its attribute details

Assets: AssetID(PK), SiteID(FK from Site), Value  -- Transaction Table

Site: SiteID(PK), SiteName  -- Master Table

I would like to create one view using joining above two tables to show SiteName instead of SiteID while building app using Assets Table.

View will be

Create View tst.vAseetAttributes

AS

SELECT aa.[AssetID],aa.[SiteID],s.[SiteName],aa.[Value]

FROM [Assets] aa

INNER JOIN [Site] s

ON aa.[SiteID] = s.[SiteID]

Please help me and provide me some ideas how to use this above view and do DML operation with changing SiteID in Assets table while changing Assets name.

Please let me know if any question.

[carlosag]

Currently it is not possible to use Views directly, however by building a Custom API you could expose that functionality through a function that you can use from PowerApps. We know this is an important scenario and will be enabling that in future releases.

[mryckman]

---

@carlosag wrote:
We know this is an important scenario and will be enabling that in future releases.

---

Hi carlosag... Do you have an estimate of when this might happen? It's a pretty cripling loss to not have views. I'm not sure how you're supposed to create a powerapp based on Azure SQL without them. I would think this would have been a top priority from the day powerapps was released.

[overclocker]

Hi , I agree that views are crucial.  Is there an API sample that shows how to do this? I assume you would need to create a RESTful api that accepts parameters and returns a data table via SQL Azure?