Exam PL-200 All Questions

View all questions & answers for the PL-200 exam

Exam PL-200 topic 3 question 45 discussion

Actual exam question from Microsoft's PL-200

Question #: 45
Topic #: 3

You are creating a cloud flow for an automation targeting Dataverse.

When a new account is created in Dataverse, the name of the account must be updated based on the following logic:

• If the Account Category Code equals Preferred Customer (1), pre append the value Preferred | to the name.
• If the Account Category Code equals Standard (2) or is not populated, pre-append Standard | to the name.

You need to define the correct formula to use for the automation.

Which formula should you use?

A. if(equals(triggerOutputs()?['body/accountcategorycode'), 1), concat('Standard | ', triggerOutputs()?['body/name']), concat('Preferred | ', triggerOutputs()?['body/name']))
B. if(equals(triggerOutputs()?['body/accountcategorycode'), 2), concat('Standard ', |triggerOutputs()?[‘body/name']), concat('Preferred | ', triggerOutputs()?['body/name']))
C. if(equals(outputs('trigger')?['body/accountcategorycode'], 1), concat('Standard | ', outputs('trigger')?['body/name']), concat('Preferred | ', outputs('trigger')?['body/name']))
D. if(equalsfoutputs('trigger')body/accountcategorycode'], 2), concat('Standard | ', outputs('trigger')?['body/name']), concat('Preferred | ',outputs('trigger')?['body/name']))

Show Suggested Answer

Suggested Answer: A 🗳️

by 5f14337 at Aug. 6, 2024, 4:32 p.m.

Comments

Submit Cancel

5f14337

Highly Voted 1 year ago

Selected Answer: A

A. if(equals(triggerOutputs()?['body/accountcategorycode'], 1), concat('Preferred | ', triggerOutputs()?['body/name']), concat('Standard | ', triggerOutputs()?['body/name'])) To define the correct formula for your automation targeting Dataverse, you should use the following logic: If the Account Category Code equals Preferred Customer (1), pre-append the value "Preferred | " to the name. If the Account Category Code equals Standard (2) or is not populated, pre-append "Standard | " to the name.

upvoted 8 times

76a12db

7 months ago

Option A doesn't have the right answer, Option A is the closest, if we reverse the "Standard |" and "Preferred |"

upvoted 2 times

...

seid92

Most Recent 4 months, 3 weeks ago

Selected Answer: B

B seems correct . Breakdown of the code: If 2 then Standard else Preferred. b also will not work if is blank (if(or(equals(triggerOutputs()?['body/accountcategorycode'], 2), equals(triggerOutputs()?['body/accountcategorycode'], null)), concat('Standard | ', triggerOutputs()?['body/name']), concat('Preferred | ', triggerOutputs()?['body/name']))) . no answer is given.

upvoted 1 times

...

gina_the_boss

7 months, 1 week ago

Selected Answer: B

- Can't be A or C. Let's ignore whether it should be triggerOutputs() or outputs('trigger'); the A and C if() formulas are showing that if the Account Category Code equals Preferred Customer (1), Standard will be appended to the name, which is NOT the requirement. - Cannot be D because it has a typo in the function 'equalsfoutputs' - That leaves us with only B

upvoted 2 times

...

mdnaseershah

7 months, 2 weeks ago

Selected Answer: B

B is correct. Breakdown of the code: If 2 then Standard else Preferred.

upvoted 3 times

...

ammu12345

7 months, 2 weeks ago

Selected Answer: A

Actual code for A should be if(equals(triggerOutputs()?['body/accountcategorycode'], 1), concat('Preferred | ', triggerOutputs()?['body/name']), concat('Standard | ', triggerOutputs()?['body/name']))

upvoted 2 times

...

Tootru2bReal

8 months, 2 weeks ago

Selected Answer: A

A is the correct answer. There is only 1 condition to prepend 'Preferred' and this is if the Code = 1 (that's the Check condition). The Standard is basically the default value if Code = 2 OR no value at all. Basically, it's standard if code is not 1. Options C & D has no change of being right. Please ignore those lol.

upvoted 1 times

Tootru2bReal

8 months ago

I really must be losing my mind. It looks like the answers switched. The actual correct syntax is: if(equals(triggerOutputs()?['body/accountcategorycode'], 1), concat('Preferred | ', triggerOutputs()?['body/name']), concat('Standard | ', triggerOutputs()?['body/name'])). When I first reviewed this question, that was an option as the letter A. I do not even see that option right now. This is why you cannot trust answers here. Just know how to write the syntax and you cannot go wrong. It's really basic if/then/else statement with Power Automate expression syntax. Nothing more and not that complicated.

upvoted 3 times

...

nqthien041292

8 months, 2 weeks ago

Selected Answer: D

Should be D A have 4 "(" but 5 ")" => syntax error B |triggerOutputs() => syntax error C Account Category Code value 1 should append Preferred instead of Standard

upvoted 1 times

...

PolloAxz24

8 months, 3 weeks ago

Selected Answer: B

B, but have a sintax error, the A put Standard if de accountcategorycode equals 1, not ok

upvoted 1 times

...

EJV87

10 months ago

Question's responses were modified, so some remarks don't make sense anymore

upvoted 2 times

...

businesselements1

10 months, 3 weeks ago

A looks fine ONLY IF if(equals(triggerOutputs()?['body/accountcategorycode'], 1), concat('Standard | ', triggerOutputs()?['body/name']), concat('Preferred | ', triggerOutputs()?['body/name'])) BUT WE HAVE ['body/accountcategorycode')

upvoted 2 times

...

EJV87

11 months, 1 week ago

Selected Answer: A

How it could be B ?

upvoted 1 times

...

Aysan

1 year ago

I feel like none of the answers are correct :(

upvoted 3 times

...