Question
You are using Power Automate to create a list of customers from a Microsoft Excel file.
The list must contain customers who meet one of the following criteria:
- Sales of less than $500,000.
- Customers who are on credit hold.
You need to create a condition to filter the list of customers.
How should you complete the filter condition? To answer, select the appropriate options in the answer area.
@[Logical operator] (less(item()?['sales'], 500000), [Condition for credit hold])
NOTE: Each correct selection is worth one point.
Explanation
Logical operator for the condition: or. A customer qualifies when they meet one of the criteria (sales under $500,000 or on credit hold), so the two expressions are joined with or(), which returns true when either argument is true. and() would return only customers who meet both criteria, and not() takes a single argument and cannot combine two conditions.
Condition for credit hold: equals(item()?['credithold'], 'true'). Inside the filter, item()?['credithold'] reads the credithold column of the current row, and equals() returns true only for customers flagged as on credit hold. empty() takes a single value and only tests whether it has no content, and not(equals(...)) inverts the test so it would match customers who are not on credit hold.
