Condition: branching on contract value

Intermediate Power Automate

Dani Kahil

Solution Architect | Microsoft MVP

The Condition action, in one sentence

Power Automate Condition action expanded in the designer, showing the boolean expression fields and the If yes / If no branch containers below

Condition evaluates a boolean expression
True → If yes branch runs
False → If no branch runs

Conditions inside Apply to Each

mermaid: green-navy: Apply to Each looping over contracts with a Condition splitting standard vs high-value renewals

Place the Condition inside the loop body
It re-evaluates per row
Each row takes its own branch independently

The string-vs-number gotcha

nanobanana: A clean flat illustration on a pure white background showing two boxes side by side. Left box labelled "STRING" containing the text '250000.00' in quotes, in dark navy. Right box labelled "NUMBER" containing 100000 (no quotes), in DataCamp green. Between them, a large red "X" symbol indicating they cannot be compared. Minimalist, no shadows.

Numeric columns sometimes surface as strings
'250000.00' vs 100000 — compared lexicographically
Result: '2...' < '1...' — wrong branch runs green
Fix: wrap with int() or float()

Writing the expression

Use items('For each')['contractvalue'] inside For Each
Wrap with int() to force numeric comparison
Operator: is greater than, value: 100000

AND, OR, and grouping

AND - every row in the group must be true
OR - at least one row must be true
Group rows to mix AND and OR in one Condition

Let's practice!

Intermediate Power Automate