Power Platform Community Forum Thread Details

When Form Submitted - Identify Row in Excel and populate word template from that row

I am trying to build a flow where when a form is submitted, an excel table is checked and based on a response in the form the data from a specific row is pulled and entered into a word template.

I was able to build a flow that pulled the last row in the table into a word document (the flow below without the 'get response details' step) but am having trouble using a unique identifier entered in the form to locate the row that should be pulled into the word template.

I thought I could add the get response details and a filter query but am not having any luck (using the 'get response details' without a filter query is resulting in word documents being generated for every row in the excel table. When I add the filter query pictured below then I get a syntax error).

Am I on the right track with this flow? If so, how do I fix it?

Or am I completely off track and there's another way I can do this?

(If possible, please explain in layman's terms, I'm a newbie to this with no tech background!)

My current flow and the filter query I tried which resulted in a syntax error:

Flow Part 1