
Announcements
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
Flow Part 2
attempted filter query (resulted in syntax error)
Hi @jand4321
First, column names with spaces cannot be used in Filter Query.
You can use Filter Array to filter.
Then traverse the value returned by Filter Array in apply to each.
Best Regards,
Levi