NEW QUESTION 110
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.
Explanation
First Box: Power Query
To filter data in a dataflow, you should use Power Query. Power Query is a data connection tool that is part of the Microsoft Power Platform, which allows you to connect to various data sources, transform, and load data into other applications such as Power BI, Excel, and Dataverse. It is a functional, case-sensitive, and data-transformation language that enables you to discover, connect, combine, and refine data sources to meet your business intelligence needs.
Power Query allows you to filter data by using its built-in functions and operators. You can filter data by using the filter, sort, and group by functions, as well as by using custom formulas and conditions. You can also use the advanced editor to write complex queries using M code, which is the underlying language used by Power Query.
Reference: https://docs.microsoft.com/en-us/power-query/
https://docs.microsoft.com/en-us/power-query/transform/filter-rows-by-condition
2nd Box: Power Fx
To filter data in a canvas app, you should use Power Fx. Power Fx is a no-code, low-code, and code-based platform that enables you to build custom business logic and automate workflows in your Power Platform apps. It allows you to create custom formulas and expressions in the app using a functional language, which allows you to filter data in the app.
Power Fx can be used to create custom formulas and expressions in the app which can filter data in the app by using its built-in functions and operators. You can filter data by using the filter, sort, and group by functions, as well as by using custom formulas and conditions. You can also use the advanced editor to write complex queries using Power Fx code.
Reference: https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/power-fx-formulas
Leave a Reply