Yes you can. Here is a link to a Microsoft doc learn.microsoft.com/en-us/power-apps/maker/data-platform/create-virtual-tables-using-connectors?tabs=sql#create-the-virtual-table-for-microsoft-excel
Hi Daniel, Thank you very much the explanation how virtual tables work. There is one thing I want to ask about virtual table is that how we do search and filtering? I tried to bring historical data from SQL Database to Powerapps for view purpose. However, there is a lot of data and required to search name or phone number. Are you able to demo how to do that?
Yes it does but in canvas apps you are already able to use other data sources including Dataverse. I see virtual tables being used heavily in the model-driven apps.
Hey Daniel, this is a great explanation of virtual tables and how to use them with Dataverse. Thanks for putting this together!🙂
You're very welcome!
I already have some great use cases for this for one of my apps, excited to see how to carry this over for one of my apps.
Hey Billy,
Always a pleasure to hear from you. All the very best in your use case.
Excellent video!!!!
Thank you very much!
Great video packed with lots helpful tips
Thanks Mike!
Hi Daniel, thanks for your great teaching.
Is it possible to make a video to teach us how we can build a Relational Model with some tables?
I'll add that to my to-blog list.
Hi Daniel, Excellent video neatly explained.
Glad you liked it!
Thanks for showcasing! Helped to understand better. Is there a similar way to keep data in Excel?
Yes you can. Here is a link to a Microsoft doc learn.microsoft.com/en-us/power-apps/maker/data-platform/create-virtual-tables-using-connectors?tabs=sql#create-the-virtual-table-for-microsoft-excel
Intro rocks bro, you seem to have that niche haha
Thanks Champ
Hi Daniel, Thank you very much the explanation how virtual tables work. There is one thing I want to ask about virtual table is that how we do search and filtering? I tried to bring historical data from SQL Database to Powerapps for view purpose. However, there is a lot of data and required to search name or phone number. Are you able to demo how to do that?
Thank you, this is very useful. Will PowerApps see the Virtual Table just like a DataVerse table as well?
Yes it will
Daniel it work with powerapps canvas?
Yes it does but in canvas apps you are already able to use other data sources including Dataverse. I see virtual tables being used heavily in the model-driven apps.
@@DanielChristian19 ok, but the issue still stands the licencing, i think that why most people use sharepoint as datasource