Hi
I don't quite think you are doing what you mean to do, or we need to fix what you have.
Ok so you are doing a list rows from Excel, based on some filter I cannot see. But I don't quite understand that because you then try to filter it, by another value.
Is this because the value you use in the Filter array action, is NOT the Key of the row? And if not, why not if thats what you need to filter by? This way your initial List Rows would simply pull back 1 row pr 0.
Either way...
1) Is the item data type a String or Number for GCSX (I thinks its an X its so small I cant read it well)
and then is your incoming a Number which you then use a string expression to convert?
2) how did you build your expression? I am concerned that it sees it as Text, and not actual expressions and hence it would fail each time
Can you go to the Flow Run itself.
A) Go to the Output of the List Rows, let's makes sure it has Rows and look at the Raw Output, so you can see what values are there and if they match the current GCSX Variable
B) Go to the Raw Input of the Filter Array, let's grab that data so we can see exactly what you are pulling
C) At the same time, let's grab the value of the GCSX variable
D) Let's make sure they are strings, let's make sure that there are no Spaces in the front or end of your converted (string) value
You may need to add a trim around your string(values) because if there are spaces it will make it not be equal.
One of these will answer your question as to why they aren't working
Share
Report
All responses (
Answers (
26,301
