ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 183 - PL-400 discussion

Report
Export

HOTSPOT

A company has a canvas app that has a screen with a gallery of contacts.

Users must be able to search the gallery by last name, email address, and country/region. They must also be able to sort by last name, followed by country/region.

You need to define the expression that meets the requirements.

How should you complete the expression? To answer, select the appropriate options from the answer area.

NOTE: Each correct selection is worth one point.


Question 183
Correct answer: Question 183

Explanation:

Box 1: SortByColums

The SortByColumns function can be used to sort a table based on one or more columns.

The parameter list for SortByColumns provides the names of the columns to sort by and the sort direction per column.

Sorting is performed in the order of the parameters (sorted first by the first column, then the second, and so on).

Box 2: Filter

The Filter function finds records in a table that satisfy a formula. Use Filter to find a set of records that match one or more criteria and to discard those that don't.

Incorrect Answers:

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. Search: Search function uses a single string to match instead of a formula.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-sort

asked 05/10/2024
abdelhafid houssa
41 questions
User
0 comments
Sorted by

Leave a comment first