CODEWITHSUNDEEP
powerapps
vijaya
vijaya

Reputation: 335

How to access views in powerapps

I need to access views in powerapps from the sql server management studio. But in powerapps, it only shows tables. How can I access views. Is there any possibility to access views in powerapps?

Upvotes: 2

Views: 3370

Answers (3)

JEuvin
JEuvin

Reputation: 1039

Just make sure that the user (SQL Server user) that you gave power apps access to has SELECT rights to the views and it will show up.

i.e.

GRANT SELECT ON [dbo].[TeamsActionPlanningTrackerView] TO powerapps

Upvotes: 0

Meneghino
Meneghino

Reputation: 1021

Azure SQL Database views and SQL Server views are now available as a data source from PowerApps directly. This feature was added in Feb 2018. Just one thing to note is that when an update to an underlying table is performed from PowerApps, then you will need to Refresh() every view based on that underlying table in order to see the changes.

Upvotes: 2

Marius
Marius

Reputation: 209

Afraid not, atleast not yet.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/PowerApps-must-also-see-SQL-Azure-Queries-not-only-Tables/idi-p/863

Vote for it! But apparantly it's in the "Planned" section - So hopefully it comes soon!

Upvotes: 1

Related Questions