Power Platform Community Forum Thread Details

Power Automate Condition Skipping Issue After Filtering Excel by Response ID

Hi Power Automate Community,

I'm working on a flow that reads data from an Excel table using the "List rows present in a table" action. I'm trying to filter rows by Response ID (which is a number) and use the data in the same row (like credentials and other columns) to control the logic in a condition and send emails.

What I’m Doing:

I have a Microsoft Form that users fill out.
After submission, I use “Add a row into a table” to save the form data into Excel.
Later, I use “List rows present in a table” and then apply a Filter Array to match the Response ID from the first submission.
The goal of the Filter Array is to return only the row (and all its columns) that matches the specific Response ID of the form submission — so I’m only working with one exact row and its data.

The Issue:

Even though the row exists and the column definitely has "YES", the condition skips doesn't run at all.

What I Need Help With:

How can I ensure I’m referencing the correct value from the filtered row?
Is there a more reliable way to use Filter Array to get the entire row of a matching Response ID?
What’s the best practice to access multiple columns from that filtered row for conditions and email generation.

Additional Context:

Response ID is a number.
Excel column names may have spaces or special characters.
I use multiple Filter Arrays to extract other related data, looping through some of them for email content.
But this specific condition is based on a single-row lookup from a matching Response ID.
Initially, I used the OData filter query in the “List rows present in a table” action to filter ResponseID eq <dynamicResponseID>, but it failed due to a type mismatch—ResponseID was stored as an integer in Excel, while the dynamic value was treated as a string. I resolved the error by ensuring the types matched and then added a Filter Array as a second layer, to confirm I’m only working with the row that has the exact same Response ID as submitted. The Filter Array works and returns the correct row, but now I’m stuck because the condition block after that keeps getting skipped, even though I’m referencing a column from the filtered item like this: @equals(toLower(trim(first(body('Filter_array'))?['Does this environment installation have credentials?'])), 'yes')