Drag and Drop Question You create a canvas app that uses data from a Microsoft SQL Server database. You use a dataflow to move some of the data from the database to Microsoft Dataverse. Users will…

The correct answer is Power Query; T-SQL. To filter data within a dataflow, Power Query is used, while filtering data directly within a canvas app requires Power Fx.

Create apps by using Microsoft Power Apps

Question

Drag and Drop Question You create a canvas app that uses data from a Microsoft SQL Server database. You use a dataflow to move some of the data from the database to Microsoft Dataverse. Users will filter the data by using the app. You need to filter data in the dataflow and in the canvas app. Which tools should you use? To answer, drag the appropriate tools to the correct requirements. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. Answer:

Exhibit

Answer Area

Drag items

Power FxPower QueryT-SQLKusto

Correct arrangement

Power Query
T-SQL

Explanation

To filter data within a dataflow, Power Query is used, while filtering data directly within a canvas app requires Power Fx.

Approach. 1. For the requirement 'Filter data in the dataflow.': Dataflows in Microsoft Power Platform (which are used to move data to Dataverse in this scenario) leverage Power Query for all data ingestion, transformation, and filtering operations. Power Query provides a visual interface and M language for these tasks. Therefore, 'Power Query' should be dragged to this requirement. 2. For the requirement 'Filter data in the canvas app.': Microsoft Power Apps canvas apps use Power Fx as their low-code language for logic, calculations, and data manipulation. Filtering data displayed within a canvas app (e.g., in a gallery or data table) is performed using Power Fx functions like Filter(). Therefore, 'Power Fx' should be dragged to this requirement.

Common mistakes.

common_mistake. Dragging 'T-SQL' to 'Filter data in the canvas app.' is incorrect. T-SQL (Transact-SQL) is specific to Microsoft SQL Server and is used for querying and manipulating data directly within a SQL Server database. While the canvas app's source data originates from SQL Server, the question asks about filtering in the canvas app itself, which uses Power Fx. T-SQL is not directly executable within a canvas app for filtering its displayed data. 'Kusto' (Kusto Query Language or KQL) is incorrect for both requirements, as it is primarily used for querying data in Azure Data Explorer or Azure Log Analytics, which are not relevant to Power Platform dataflows or canvas apps in this context.

Concept tested. The underlying technical concept tested is the knowledge of the specific data querying and manipulation languages or tools used within different components of the Microsoft Power Platform ecosystem, specifically Power Query for dataflows and Power Fx for canvas apps, and distinguishing them from other database or analytics query languages like T-SQL or Kusto.

Topics

#Dataflows#Power Query#Canvas Apps#Data Filtering

Community Discussion

No community discussion yet for this question.

Full PL-200 Practice