Power Automate Cloud Flow Condition Expressions
Short answer
Use the greater() expression function to verify if OrderTotal exceeds 1,000, and use the contains() expression function to check if the substring VIP is present within CustomerName.
Question
A company processes customer orders by using a cloud flow.
The flow must evaluate the following conditions:
Route orders for approval when the OrderTotal exceeds 1,000.
Flag orders when the CustomerName identifies the string “VIP”.
You need to configure flow conditions.
Which expressions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Key Takeaways
The question tests knowledge of specific Power Automate expression functions: greater() for numeric comparisons and contains() for substring detection within strings.
Learn how to configure Power Automate cloud flow conditions using greater() for numeric thresholds and contains() for string substrings to route orders based on value and customer type.
Common mistake: Learners often confuse equals() with contains(), requiring an exact match rather than a substring presence, or misuse the greater() function by providing incorrect argument order.
Expert Analysis
This question tests the ability to construct valid Power Automate expressions for conditional logic within cloud flows. The scenario requires two distinct evaluation mechanisms: a numeric comparison and a string containment check.
Numeric Evaluation Logic
To determine if OrderTotal exceeds 1,000, you must use the greater expression function. In Power Automate, the greater function takes two arguments: the first value (the variable or field) and the second value (the threshold). Therefore, the correct syntax is greater(variables('OrderTotal'), 1000). This returns true if the order total is strictly greater than 1,000. A common error is using equals with a range or misordering the parameters, which would fail to capture the "exceeds" condition correctly.
String Containment Logic
To identify if CustomerName contains the substring "VIP", you must use the contains expression function. This function checks if a specific substring exists within a larger string. The correct syntax is contains(variables('CustomerName'), 'VIP'). Note that this check is case-insensitive by default in many contexts, but relies on exact substring matching. It does not require the entire string to be "VIP", only that "VIP" appears anywhere within CustomerName. Using equals would incorrectly require the name to be exactly "VIP", and startswith would miss VIPs whose names do not begin with that string.
Operational Consequence Getting these expressions wrong results in flow failures or incorrect routing. If the greater function is omitted, high-value orders might bypass approval. If contains is replaced with equals, legitimate VIP customers with full names (e.g., "John VIP") would not be flagged. Understanding the specific built-in functions for data types (numeric vs. string) is critical for AB-410 success.
answer_letter is empty because there are no option letters.
Official Reference
- https://learn.microsoft.com/en-us/power-automate/desktop-flows/functions-list#comparison-functions
- https://learn.microsoft.com/en-us/power-automate/desktop-flows/functions-list#string-functions
These links open the official vendor documentation in a new tab.
Exam Strategy
When configuring conditions in Power Automate, always match the data type to the correct function: use greater/less/equal for numbers and contains/startswith/endswith for text. Verify your logic covers the specific requirement (e.g., 'exceeds' means >, not >=).
Frequently Asked Questions
What is the syntax for the greater() function?
Does contains() distinguish between uppercase and lowercase?
Discussion 2 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 2
-
aed747e 👍 1Use the greater() expression function to verify if OrderTotal exceeds 1,000. Use the contains() expression function to check if the substring "VIP" is present anywhere within the CustomerName string.
-
exam_upskill 👍 11. Greater() 2. Contains()
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.