Exam PL-500 topic 5 question 68 discussion

Actual exam question from Microsoft's PL-500

Question #: 18
Topic #: 5

HOTSPOT -
You are creating a custom selector for a Microsoft Excel workbook by using a Power Automate.

Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Stinow at Dec. 12, 2022, 12:57 p.m.

Comments

Submit Cancel

Mail20

Highly Voted 11 months, 1 week ago

Tested and correct version is : 1. Yes 2. Yes 3. The value of any cell defined by RowIdx variable in column A 4. Update the table name in line 5

upvoted 6 times

...

charles879987

Most Recent 1 year, 8 months ago

this question is very technical and needs understanding of coding selector. normally this is done with simple tools like in https://learn.microsoft.com/en-us/power-automate/desktop-flows/build-custom-selectors

upvoted 3 times

charles879987

1 year, 8 months ago

agreed with Anchov except answer 3: 1. Yes - the $ means "ends with" 2. Yes - The @ is ID means regex, In Regex * means 0 or more of the preceding character 3. value in cell A3. RoxIDx variable = 3 which is the row number 4 . Update the table name in line 5

upvoted 3 times

soulebi

1 year, 5 months ago

correct in line 6 its A 3

upvoted 1 times

...

giga6

1 year, 9 months ago

seems correct to me

upvoted 2 times

...

Anchov

1 year, 11 months ago

I choose Yes - the $ means "ends with" Yes - The @ is ID means regex, In Regex * means 0 or more of the preceding character The value of any cell defined by RowIDx variable in Column A Update the table name in line 5

upvoted 3 times

...

Stinow

2 years ago

With regards to the first one, doesn't Id$ mean it has to end with the chosen value?

upvoted 2 times

...