In this video, you'll see an amazing 😲 new preview feature that will change the way we have to architect Power Apps and Dynamics 365 using Dataverse forever. The virtual connector feature allows you to link to outside sources in real time and perform read/update/delete operations without having to import all of that data.
⚡You can get the solution from AppSource https://appsource.microsoft.com/en-us/product/dynamics-365/mscrm.connector_provider?tab=Overview
📰Documentation link: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/virtual-entities/create-virtual-tables-using-connectors
You will also find known limitations and troubleshooting guidelines for common issues in the documentation.
To begin this example, you'll need a connection to my database in the cloud. Go to https://make.powerapps.com. Go to Data, Connections and Create a new SQL Server Connection.
👉Here's the info you'll need for the connection:
✔️Type: SQL Server
✔️Authentication Type: SQL Server Authentication
✔️Server: pragmaticworks.database.windows.net
✔️Database: Demo
✔️UserName: DemoUser
✔️Password: DemoPW123 (yes, it's case sensitive)
✔️Gateway: None selected
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/
Let's connect:
✔️Twitter: https://twitter.com/PragmaticWorks
✔️Facebook: https://www.facebook.com/pragmaticworks/
✔️Instagram: https://www.instagram.com/pragmatic.works
✔️LinkedIn: https://www.linkedin.com/company/pragmaticworks
✔️YouTube: https://www.youtube.com/pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#powerapps #dataverse #powerappsportals #connectors #dynamics #dynamics365 #linkedtables #virtualentity
0:00 Whare are virtual connectors
2:00 Installing the virtual connector
4:30 Creating the connection
5:10 Creating the virtual connection reference
6:30 Creating the virtual connector data source
10:32 Creating the app registration
15:00 Creating the virtual connector table
19:00 Joining to the table
23:00 Creating the app
-~-~~-~~~-~~-~-
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
https://www.youtube.com/watch?v=ENvLrYFNeqY
-~-~~-~~~-~~-~-