Expression.Error: We cannot apply field access to the type Text.

You used record/field access (like [Field]) on a value that is text, not a record or table.

Why it happens

• Indexing into a text value with [...].
• A column expected to hold a record or table actually holds text.
• A step order problem — a nested value wasn't expanded before it was accessed.

How to fix it

1. Check the value's type in the previous step; expand the record or table column first.
2. Fix the earlier step that produced text where a structured value was expected.
3. Use try [Field] otherwise null while you diagnose which rows differ.