Power Apps Training
PowerApps Training
1. An introduction to PowerApps
a. What is PowerApps?
b. Advantages
c. How to get PowerApps access?
d. What is Canvas App and Model-Driven App?
2. Getting started with PowerApps
a. What is template and how to use?
b. Building a canvas app with a data source
c. Working with controls
d. Formulas
e. Testing the app changes
f. App settings
g. Publishing and Sharing the app
h. How to restore and work with versions
i. Mobile app
3. Branding and customizations
a. Duplicate screens
b. Colors, fonts
c. Screen backgrounds
d. Buttons, Icons
e. Hide and Show
f. Timer control
4. PowerApps Controls
a. Text controls
b. Other controls
c. Charts
d. Forms
e. Gallery / Data tables
5. Data Source
a. Which database to use?
b. Gateways
c. Data storage
6. Model Driven app
a. What is model-driven app
b. When to use
c. How to create
7. PowerApps Integration
a. Embedding in MS Teams
b. Embedding in SharePoint
c. Connecting to a flow
8. Administration
a. Migration
b. App usage (analytics)
c. Restrict PowerApps to a user
d. Manage environments
How to execute the T-SQL to Query Data from CDS and Dynamics 365 CE from Power Platform
Microsoft recently released Power Platform 2020 wave 1 in that one of the great feature is connecting CDS/Dynamics 365 CE database from SSMS.
Earlier if you want to query the CDS/CE cloud database the only option is dumping the data into our SQL Database using SSIS/Scribe or Data Export Services solution has to be configured but now we are able to directly connect to CDS and execute T-SQL queries from SSMS.
- The CDS environment version should be 9.1.0.17437 or higher and needs to be enabled in the backend.
- Enable the TDS endpoint for CDS for your environment from Power Platform Administration.
- SQL server management studio 18.4 or higher version to connect with the CDS database
- This only for querying data from a CDS database. You will not be able to do insert or update.
- Security; note that you read security permissions in CRM carry over to SQL – if you do not read for the account entity for example you cannot query it from the CDS SQL point.
Popular Posts
-
Aldiablos Infotech Pvt. Ltd. is an ISO 9001-2008 Certified Company providing BPO and IT Services Pan India and accross the Globe. We are h...
Contact US
EMail: info@crmonce.com |
Phone Number: +91 9493916112,+91 8096556344 |
Whatsapp: +91 9493916112 |
Skype for Business: umamahesh@crmonce.com |
Upcoming Sessions
Dynamics365 CRM |
D365 CRM Portals/Adxstudio |
CRM Advanced Programming with Azure Integrations |
RESCO MOBILE Development |