When Power Automate reads Excel with List rows present in a table, cell values can arrive as:
- null
- "" (empty string)
- " " (spaces)
- actual values (text/number/date)
The Excel connector does NOT normalize these, so you must clean them before checking.
To check whether an Excel cell has a value or is blank after using List rows present in a table, use these expressions inside your Condition:
Check if the cell is blank
equals(trim(string(coalesce(items('Apply_to_each')?['ColumnName'], ''))), '')
Check if the cell has any value
not(equals(trim(string(coalesce(items('Apply_to_each')?['ColumnName'], ''))), ''))
Replace ColumnName with your actual Excel column name.
These handle:
- nulls
- empty strings
- cells with spaces
- numbers/dates (because of the string() conversion)
You can drop them directly into your Condition block, no additional steps needed.
Why the expressions work:
coalesce() → converts null to ''
string() → normalizes numbers/dates to text so checks don’t break
trim() → removes whitespace
equals(..., '') → detects blank values
not(equals(...)) → detects non‑blank values
This is the most reliable pattern for evaluating whether a cell is empty or not when looping through rows.
✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.
