Dataverse views

[vshah2]

Hello Team,

I have 3 to 4 tables and I'm trying to build query which gathers the data from these tables and show it on PowerApps canvas apps. Since I build the query in PowerApps canvas app, It's a lot of time to query the data. So is there a way I can create the custom view in Dataverse and use that view in PowerApps canvas apps to improve the performance?

Thanks.

[rampprakash]

Hello @vshah2,

Could you please share me the 3 Table Relationship so that we can help you the same.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[dpoggemann]

Hi @vshah2 ,

You can definitely utilize a view as long as the relationships in Dataverse allow you to bring the information together into a view with a primary table.  Example is you would need a table with lookups to other tables and be able to bring fields from those tables into the view as this is the only way to bring in fields from other tables on to a Dataverse view.  One nice thing about the view is you can create complex criteria to pull the records you want into the results.

Good blog article on using views in Canvas Apps:  http://powerappsguide.com/blog/post/how-to-create-and-use-dataverse-views 

Hope this helps.  Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

[vshah2]

@dpoggemann - Thank you. Let me give it a try. I believe this is going to be preferred practice to build a view in Dataverse and use in canvas app right? That will improve the performance as well I guess. Thanks.

[dpoggemann]

Hi @vshah2 ,

Yes, this would be recommended if possible to do the heavy lifting, if fits within the rules of constructing a view.

Hope it works well.  Please accept if it does answer the question or Like if helps in any way.

Thanks,

Drew