Podcast
Questions and Answers
What features are only available in Microsoft Dataverse?
What features are only available in Microsoft Dataverse?
- Mobile offline
- NoSQL storage
- File and image support
- Multiple currency support (correct)
What type of column should you create in Microsoft Dataverse to allow for adding more options or changing labels in the future?
What type of column should you create in Microsoft Dataverse to allow for adding more options or changing labels in the future?
- Choice (correct)
- Choices
- Text
- Yes/No
Which type of column should be used in Microsoft Dataverse to capture the severity of a problem reported by customers?
Which type of column should be used in Microsoft Dataverse to capture the severity of a problem reported by customers?
- Choice (correct)
- Yes/No
- Choices
- Autonumber
What should you do to share a model-driven app created in Power Apps using a custom Microsoft Dataverse table?
What should you do to share a model-driven app created in Power Apps using a custom Microsoft Dataverse table?
Which Microsoft Power Platform service should be used to connect to an in-house web application's API for automation?
Which Microsoft Power Platform service should be used to connect to an in-house web application's API for automation?
What is a feature of a canvas app?
What is a feature of a canvas app?
Which Microsoft Power Platform service should a company use to analyze customers' reviews on a social platform?
Which Microsoft Power Platform service should a company use to analyze customers' reviews on a social platform?
In a customer self-service portal, what Microsoft Power Platform feature should be used to extract city and product names from complaints?
In a customer self-service portal, what Microsoft Power Platform feature should be used to extract city and product names from complaints?
When restricting access to social media connectors in Microsoft Power Platform, what should you configure?
When restricting access to social media connectors in Microsoft Power Platform, what should you configure?
Which connector should be used in Microsoft Power Platform to read text from uploaded images?
Which connector should be used in Microsoft Power Platform to read text from uploaded images?
How can you prevent external leakage of corporate data in Microsoft Power Platform?
How can you prevent external leakage of corporate data in Microsoft Power Platform?
To require users to fill in their subscriber ID in uppercase when posting comments on a blog site in Power Automate, which function should be used?
To require users to fill in their subscriber ID in uppercase when posting comments on a blog site in Power Automate, which function should be used?
What should be created to allow suppliers to register themselves and access information in a web-based knowledge base?
What should be created to allow suppliers to register themselves and access information in a web-based knowledge base?
Which feature allows users to build custom apps without writing code in Microsoft Power Platform?
Which feature allows users to build custom apps without writing code in Microsoft Power Platform?
Which type of column in Microsoft Dataverse allows users to select a single value from a list of options?
Which type of column in Microsoft Dataverse allows users to select a single value from a list of options?
Which Microsoft Power Platform service should be used to connect to a custom web application's API for data exchange and automation?
Which Microsoft Power Platform service should be used to connect to a custom web application's API for data exchange and automation?
What is a unique feature of Microsoft Dataverse that is not available in Microsoft Dataverse for Teams?
What is a unique feature of Microsoft Dataverse that is not available in Microsoft Dataverse for Teams?
Which statement is true about sharing a model-driven app created in Power Apps using a custom Microsoft Dataverse table?
Which statement is true about sharing a model-driven app created in Power Apps using a custom Microsoft Dataverse table?
Match the following terms with their correct descriptions:
Match the following terms with their correct descriptions:
Match the following statements with the correct Microsoft Dataverse features:
Match the following statements with the correct Microsoft Dataverse features:
Match the following actions with the correct requirements:
Match the following actions with the correct requirements:
Match the following connectors with their specific functionalities:
Match the following connectors with their specific functionalities:
Match the following features with their correct descriptions:
Match the following features with their correct descriptions:
Every table in Microsoft Dataverse has a ______ that uniquely identifies each row.
Every table in Microsoft Dataverse has a ______ that uniquely identifies each row.
Microsoft Dataverse for Teams does not support ______ or Mobile offline.
Microsoft Dataverse for Teams does not support ______ or Mobile offline.
The ______ field allows a user to select a single value from a list of options.
The ______ field allows a user to select a single value from a list of options.
The ______ field allows a user to select more than one value from the list of options.
The ______ field allows a user to select more than one value from the list of options.
To share a ______ app, a security role must be assigned to a user.
To share a ______ app, a security role must be assigned to a user.
The ______ connector is used to interact with Dataverse data in Microsoft Power Platform.
The ______ connector is used to interact with Dataverse data in Microsoft Power Platform.
______ flows are guided UI flows in model-driven apps for streamlined data entry.
______ flows are guided UI flows in model-driven apps for streamlined data entry.
What is the primary key column in Microsoft Dataverse?
What is the primary key column in Microsoft Dataverse?
How can a custom connector be made available to other makers in Microsoft Power Platform?
How can a custom connector be made available to other makers in Microsoft Power Platform?
What is the purpose of policies on custom connectors in Microsoft Power Platform?
What is the purpose of policies on custom connectors in Microsoft Power Platform?
What is the difference between the Choice and Choices fields in Microsoft Dataverse?
What is the difference between the Choice and Choices fields in Microsoft Dataverse?
What is the purpose of the Dataverse connector in Microsoft Power Platform?
What is the purpose of the Dataverse connector in Microsoft Power Platform?
What is the purpose of the Excel Online (Business) connector in Microsoft Power Platform?
What is the purpose of the Excel Online (Business) connector in Microsoft Power Platform?
What is the purpose of business process flows in Microsoft Power Platform?
What is the purpose of business process flows in Microsoft Power Platform?
Which Microsoft Power Platform service should be used to connect to a custom web application's API for data exchange and automation?
Which Microsoft Power Platform service should be used to connect to a custom web application's API for data exchange and automation?
In Microsoft Dataverse, the primary key column uniquely identifies each row in a table.
In Microsoft Dataverse, the primary key column uniquely identifies each row in a table.
To share a model-driven app, a co-owner can be selected instead of assigning a security role.
To share a model-driven app, a co-owner can be selected instead of assigning a security role.
The Choices field in Microsoft Dataverse allows users to select multiple values from a list of options.
The Choices field in Microsoft Dataverse allows users to select multiple values from a list of options.
Microsoft Dataverse for Teams supports multiple currencies.
Microsoft Dataverse for Teams supports multiple currencies.
The custom connector needs to be shared to make it available to other makers.
The custom connector needs to be shared to make it available to other makers.
Flashcards
Sentiment Analysis
Sentiment Analysis
A pre-built model in AI Builder that analyzes text to understand the sentiment expressed, such as positive, negative, or neutral.
Connectors
Connectors
The ability to connect to external systems and services to exchange data.
Custom Table
Custom Table
A custom Microsoft Dataverse table that is not managed by the system and can be created directly within the environment.
Portal App
Portal App
Signup and view all the flashcards
Power Platform CoE Toolkit
Power Platform CoE Toolkit
Signup and view all the flashcards
Choice Field
Choice Field
Signup and view all the flashcards
Choices Field
Choices Field
Signup and view all the flashcards
Text Recognition
Text Recognition
Signup and view all the flashcards
One-to-Many Relationship
One-to-Many Relationship
Signup and view all the flashcards
Many-to-Many Relationship
Many-to-Many Relationship
Signup and view all the flashcards
Primary Key
Primary Key
Signup and view all the flashcards
Data Policies
Data Policies
Signup and view all the flashcards
Canvas Apps
Canvas Apps
Signup and view all the flashcards
Model-driven Apps
Model-driven Apps
Signup and view all the flashcards
AI Builder
AI Builder
Signup and view all the flashcards
Language Detection
Language Detection
Signup and view all the flashcards
Embed Power BI Tiles
Embed Power BI Tiles
Signup and view all the flashcards
Dataverse Connector
Dataverse Connector
Signup and view all the flashcards
Excel Online (Business) Connector
Excel Online (Business) Connector
Signup and view all the flashcards
Azure Blob Storage
Azure Blob Storage
Signup and view all the flashcards
Choice Column
Choice Column
Signup and view all the flashcards
Choice Column
Choice Column
Signup and view all the flashcards
Lookup Column
Lookup Column
Signup and view all the flashcards
Custom Connectors
Custom Connectors
Signup and view all the flashcards
Paconn
Paconn
Signup and view all the flashcards
Auditing
Auditing
Signup and view all the flashcards
Customer
Customer
Signup and view all the flashcards
Microsoft Entra ID Conditional Access
Microsoft Entra ID Conditional Access
Signup and view all the flashcards
Microsoft Dataverse for Teams
Microsoft Dataverse for Teams
Signup and view all the flashcards
Study Notes
Microsoft Power Platform Connectors
- Azure Cognitive Services is used to read text from uploaded images
- Custom connector is used to connect to a custom web application's API
Security and Compliance
- Create data policies to prevent external leakage of corporate data
- Data loss prevention (DLP) policy is used to restrict access to social media connectors
Power Apps
- Canvas apps can be used to create a web-based knowledge base
- Portal apps can be used to allow suppliers to register themselves to gain access to information stored in the knowledge base
Power Automate (formerly Microsoft Flow)
- Expression function is used to save the subscriber ID in uppercase
- AI Builder is used to analyze customers' reviews on a social platform to understand how they feel about a product
Microsoft Dataverse
- Choice column type allows users to select one option from a list of available values
- Choice column type allows users to select more than one option from the list of available options
- Lookup column type is created when a one-to-many relationship is created between two tables
- Many-to-many relationship is used to create a relationship between customer and product
- Standard table type is used for the Currency table
- One environment can have one Microsoft Dataverse instance
- Three environments, each with one instance, can be created for three branch offices
AI Builder
- Sentiment analysis, text recognition, language detection, object detection, and document processing are prebuilt models available in AI Builder
- AI Builder can be used to extract entity information such as city, color, phone number, and location from text
- AI Builder is used to analyze customers' reviews on a social platform to understand how they feel about a product
Microsoft Power Platform Features
-
Control functionality with Microsoft Power Fx formulas can be used in canvas apps
-
Include artificial intelligence can be used in canvas apps
-
Embed entire Power BI dashboards cannot be done in canvas apps, but individual tiles from a Power BI dashboard can be embedded### Azure Cognitive Services
-
Can analyze images and extract printed and handwritten text from the image
-
Has multiple connectors for Microsoft Power Platform
-
Can analyze images but cannot analyze the contents of files in Azure Blob storage
Microsoft Power Platform Connectors
- Azure Blob storage connector is used for storing and accessing files, not analyzing contents
- Microsoft Dataverse can store files but cannot analyze contents
- Microsoft Teams connector can create channels and post messages but cannot analyze files
Data Security and Policies
- Data policies prevent apps or flows from connecting to two different data sources that may allow data to be accessed or copied outside of the organization
- Microsoft Entra ID conditional access can control when a user can access a Power Apps app using various signals like location and device
- CoE toolkit enables monitoring of apps, flows, and connectors used within the organization, but does not prevent data leakage on its own
Power Apps and Power Automate
- Power Apps is used to create apps for end users, including canvas apps, model-driven apps, or a Power Pages site
- Power Apps cannot detect sentiment in text or extract information from text on its own
- AI Builder is used to detect sentiment in text and extract entity information, and can be used in Power Apps apps or Power Automate flows
AI Builder
- Has prebuilt models, including sentiment analysis, text recognition, and language detection
- Also has custom models, such as object detection, category classification, and document processing
- Can be used directly in Power Apps applications or Power Automate flows
Microsoft Dataverse
- Has a single instance per environment
- Environment is required to host a Microsoft Dataverse instance
- Has standard tables, including out-of-the-box tables, such as the Currency table
- Custom tables are unmanaged tables created directly in the Microsoft Dataverse environment
- Virtual tables are custom tables with columns containing data from an external data source
Data Modeling
- Lookup columns are created on the related table when a one-to-many relationship is created between two tables
- Lookup columns are also known as foreign keys
- Alternate keys are created for integrations with other systems
App Development
- Canvas apps are built from scratch and require more time to build than portal apps
- Canvas apps require users to be authenticated with Microsoft Entra ID
- Canvas apps can include AI controls for form processing and object detection
- Model-driven apps do not allow for self-service registration to gain access to the app
Microsoft Power Platform CoE Toolkit
- Enables monitoring of apps, flows, and connectors used within the organization
- Enables managing of data policies
- Does not prevent data leakage on its own### Customer and Tables
- Customer is a special lookup column that represents an account or a contact
- Customer column cannot be created by creating a one-to-many relationship
- Every table in Microsoft Dataverse has a primary key that uniquely identifies each row
- Primary key column is created when the table is created
Custom Connectors
- Custom connector needs to be shared to allow other makers to use it in their apps and flows
- Policies on custom connectors are used to configure the connector at runtime
- Policies do not make the connector available for other makers
- Paconn command line tool can be used for development of custom connectors
- Custom connector can only be submitted if the connector needs to be available publicly
Microsoft Dataverse
- Microsoft Dataverse for Teams does not support multiple currencies or Mobile offline
- Microsoft Dataverse and Microsoft Dataverse for Teams both have file and image support
- Microsoft Dataverse for Teams also supports relational storage
Fields
- Choice field allows user to select a single value from a list of available values
- User also has the option not to choose any value from the options, in which case the data for the column will be saved as null in data store
- Choices field allows a user to select more than one value from the list of available options
- Approve and Reject options can be enabled using Yes/ No column type, but it can have only two values
- Text fields allow free user text without any data validations, but cannot be used to display options to user
Security and Access
- For users to have access to the custom table in the app, a security role must be assigned to it
- To share a model-driven app, a security role must be assigned to a user when sharing the app
- When sharing a canvas app, a co-owner can be selected
- Navigating to the details page will give the user the location of the app, but it will not grant any permissions to the user
- If the user has not already been granted permission, they will get an error message when they load the Power Apps app
Microsoft Power Platform
- Microsoft Power Platform offers many prebuilt connectors
- In scenarios where you need to integrate with a custom web application, you have the option to build a custom connector to connect to the custom APIs for data exchange
- Dataverse connector is a prebuilt connector in Microsoft Power Platform that is used to interact with Dataverse data
- Excel Online (Business) connector is a prebuilt connector in Microsoft Power Platform that is used to connect and work only with Excel files in document libraries supported by Microsoft Graph
- Business process flows are guided UI flows in model-driven apps for streamlined data entry
Azure Cognitive Services
- Azure Cognitive Services can analyze images and extract printed and handwritten text from the image
- Azure Cognitive Services has multiple connectors for Microsoft Power Platform
- Azure Blob storage has a connector, but it is used for storing and accessing files, not analyzing the contents of the files
Data Policies
- Data policies prevent an app or a flow from connecting to two different data sources that may allow data to be accessed or copied outside of the organization
- Microsoft Entra ID conditional access can control when a user can access a Power Apps app using various signals such as location and device
- The Microsoft Power Platform CoE toolkit will enable monitoring of the apps, flows, and connectors used within your organization
Auditing
- Auditing in Microsoft Dataverse captures changes to data in Microsoft Dataverse tables
- Auditing does not prevent data leakage
Portal Apps
- A portal app, using the Partner portal template, allows users to register themselves for your portal app web site
- The knowledge management feature in the app can be used to allow suppliers to read documentation from the company
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge on Microsoft Power Platform connectors by answering questions related to selecting the appropriate connector for reading text from uploaded images, preventing external leakage of corporate data, and more.