Exam PL-400 topic 5 question 20 discussion

Actual exam question from Microsoft's PL-400

Question #: 20
Topic #: 5

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.
Hot Area:

Show Suggested Answer

Suggested Answer:

by jagibe at Sept. 2, 2022, 12:14 p.m.

Comments

Submit Cancel

jagibe

Highly Voted 1 year, 11 months ago

SortByColumns Search Ref: https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup#syntax

upvoted 37 times

SashM

1 year, 7 months ago

correct

upvoted 1 times

...

PowerRangers

Highly Voted 1 year, 6 months ago

The syntax is invalid for filter

upvoted 5 times

...

Juan0414

Most Recent 5 months, 1 week ago

SortByColumns Search

upvoted 1 times

...

ziggy1117

1 year ago

SortByColumns Search Search(Customers, SearchInput.Text, "Name", "Company") Similar to using the in operator, the Search function searches the Customers data source for records in which either the Name column or the Company column contains the search string (for example, co) anywhere within it. The Search function is easier to read and write than Filter if you want to specify multiple columns and multiple https://www.examtopics.com/exams/microsoft/pl-400/view/31/#in operators. You must enclose the names of the columns in double quotation marks. https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup#syntax

upvoted 3 times

...

shivdix

1 year, 7 months ago

For 2; Both Filter and Search will work. Since there is no Formula. I'll go with Search.

upvoted 1 times

...