Hi
i have a microsoft form that is linked to an excel file where all the people answers go. One sheet has a list of al the answers that gets updated automatically when someone submits the form. the second sheet is a worksheet i created that has various formulas that transforms the persons answers to sentences. In that sheet i have created a table with a row where all the answers go (from the last person that submitted the form)
im hoping that someone can help me out as i cannot figure out where i am going wrong. i have created a flow that is supposed to pull the data from the table that has all the answers in it. the runs without any errors but it is not pulling the correct row. im desperate to find a solution
i have attached an image of the flow setup as well as my table in excel (the table is called answers, i have a key column called test and in that row i have the word cheese)
as you can see from the output, it shows column 2 answer is french fry (this was the answer of a person who filled the form 4 times earlier than this one), when in reality if you look at my table it should be daisy busgang
Please any help would be appreciated
