ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-200 All Questions

View all questions & answers for the PL-200 exam
Go to Exam

Exam PL-200 topic 2 question 8 discussion

Actual exam question from Microsoft's PL-200
Question #: 8
Topic #: 2
[All PL-200 Questions]

HOTSPOT -
You have a canvas app that contains the following text input fields: Id, FirstName, LastName. The app also has a button named Button1.
The OnSelect property for Button1 contains the following expression:
Collect(People, {Id:Id.Text, FirstName:FirstName.Text, LastName:LastName.Text})
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Yes -
If the data source doesn't already exist, a collection is created.

Box 2: No -
Note: The Collect function adds records to a data source. The items to be added can be:
✑ A single value: The value is placed in the Value field of a new record. All other properties are left blank.
✑ A record: Each named property is placed in the corresponding property of a new record. All other properties are left blank.
✑ A table: Each record of the table is added as a separate record of the data source as described above. The table isn't added as a nested table to a record. To do this, wrap the table in a record first.

Box 3: No -
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect
by PL_600 at Sept. 3, 2022, 9:18 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
PL_600
Highly Voted 2 years, 2 months ago
Correct
upvoted 17 times
...
derekmalaga
Highly Voted 1 year, 2 months ago
Given Answer is correct: A) YES - Collect() will create the collection if it does not exist B) NO - Collect() will create a duplicated item. To update the record you should use a different formula C) NO - Using first: Collect(colMyGallery,{id:1,Name: "John", Attendance: false) and later Collect(colMyGallery,{id:2,Name: "Lisa",Attendance:false, Age: 30}) will add a new column to the collection and won't trigger any error Id Name Attendance Age 1 John false 2 Lisa false 30
upvoted 6 times
...
jkaur
Most Recent 6 months, 4 weeks ago
YNN correct
upvoted 2 times
...
Joey444
1 year ago
1. Yes 2. No 3. No
upvoted 1 times
...
kty
1 year, 3 months ago
should press the button, so N,N,Y
upvoted 2 times
HJLN
1 year, 2 months ago
The button does not need to be pressed for the People collection to be created. The moment that you complete typing the proper function, the table for the collection will be created with a blank data. So Y,N,N
upvoted 1 times
...
...
Jons123son
1 year, 7 months ago
Y N Y You cannot "update" a new field into an existing record within a collection. You will get a type error. You can collect a new record with the new field and then update the field in existing records.
upvoted 6 times
HJLN
1 year, 2 months ago
There will be no error the entire collection will be erased. I tried it on my tenant.
upvoted 3 times
...
...
Ikhalil
1 year, 7 months ago
Correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago