How to Write Trigger Conditions for Filtering Choice Columns in Dataverse Cloud Flows?
Table of Contents
Question
You have an automated cloud flow that connects to a Microsoft Dataverse table named Cruises, which has a schema name of Cr8ec_cruises. The Cruises table has the following choices columns:
- Boat name
- Destination
The Boat name column contains the values Oasis, Aqua, and Serendipity. The Destination column contains the values of the following three Mexico destinations: Puerto Vallarta, Cozumel, and Ensenada.
You need to ensure that the flow runs only for Dataverse rows that have a destination set to Cozumel and a boat name set to Oasis.
Which trigger condition should you use?
Select only one answer.
A. @and(equals(triggerOutputs()?[‘cr8ec_destination’], ‘Cozumel’), equals(triggerOutputs()?[‘cr8ec_boatname’],’Oasis’))
B. @and(equals(triggerOutputs()?[‘_cr8ec_destination_label’], ‘Cozumel’), equals(triggerOutputs()?[‘_cr8ec_boatname_label’],’Oasis’))
C. @and(equals(triggerBody()?[‘cr8ec_destination’], ‘Cozumel’), equals(triggerBody()?[‘cr8ec_boatname’],’Oasis’))
D. @and(equals(triggerBody()?[‘_cr8ec_destination_label’], ‘Cozumel’), equals(triggerBody()?[‘_cr8ec_boatname_label’],’Oasis’))
Answer
D. @and(equals(triggerBody()?[‘_cr8ec_destination_label’], ‘Cozumel’), equals(triggerBody()?[‘_cr8ec_boatname_label’],’Oasis’))
Explanation
This item tests the candidate’s knowledge of implementing complex expressions in flow steps.
The trigger condition expression restricts the triggering of flow based on a condition. The question symbol (?) is an optional parameter that will handle null values. The TriggerBody() expression is used to fetch values from the body of the trigger. TriggerOutputs() is used to read values from the trigger body and trigger header. The expression triggerBody()?[‘cr8ec_destination’] will return the internal value of the Destination column, not the label for comparison. The expressions triggerBody()?[‘_cr8ec_destination_label’] and triggerBody()?[‘_cr8ec_destination_label’] will return the Destination and Boat name labels for comparison.
Microsoft Power Platform Developer PL-400 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Power Platform Developer PL-400 exam and earn Microsoft Power Platform Developer PL-400 certification.