Hi there,
I'm new to flow and I'm trying to create a simple flow that checks a value in excel then sets a variable based on the result. In MyTable I have only one row, (Ref and Result). Result can be (base on excel formula) either yes or no (or could be true/false or 0/1 or whatever). Then sets the variable to say 'it's true' or 'it's false'.
I've tried with 'list rows in a table' and with 'get row' both adding a filter query or adding a condition... the result is always the same, the flow always returns the no/false/0 answer. What am I doing wrong? I know this should be fairly simple and yet I can't get it to work. Please help!