DRAG DROP (Drag and Drop is not supported)
You are designing new functionality for an existing model-driven app.
A field must display multiple selections to the user, enabling the user to select a value.
You need to determine which column type can support the required scenarios.
Which column type should you use? To answer, drag the appropriate column types to the correct scenarios. Each column type 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.
NOTE: Each correct selection is worth one point.
Select and Place:
- See Explanation section for answer.
Answer(s): A
Explanation:
Box 1: Lookup
The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria.
Besides the normal formula operators, you can use the in and exactin operators for substring matches.
[!INCLUDE [record-scope]../../includes/record-scope.md)]
Example:
Filter(IceCream, OnOrder> 0) - Returns records where OnOrder is greater than zero.
Box 2: Global choice and Lookup
Box 3: Global choice
A choice column provides a list of values for users to pick from. They help streamline data entry in turn ensuring clean data. There are two types - local and global.
Local choices can are local to the table and column that they are created for. They cannot be reused on other tables. For example, a list of statuses for an application may not apply anywhere else (e.g. Submitted, In Review, Approved, Rejected). On the other hand, global choices are available across all tables and columns allowing them to be reused.
Reference:
https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup https://thepoweraddict.com/how-to-work-with-choice-columns-in-dataverse/