
Quick Fix:
Better Solution:
Avoid using agent instructions for filtering. Instead, use a Power Fx/Power Automate action:
Filter(dataverse_table,
xxx_name = Topic.section_name And
xxx_version = Topic.version
)
This approach is deterministic—no unexpected values, and results will always match exactly.
Generative agents are not reliable for precise data queries. For Dataverse operations, structured actions are recommended.