Filter Array with no Outputs [], only when resubmit flow

[luizhr]

I'm trying to find a solution about this. 

My Filter Array output is giving no results [ ] even after a adding Parse JSON / variable.

The strange is when I Resubmit the Flow, the results appear in Outputs.

Does anybody have a clue about what's happening ?

1st run - flow

After Resubmit

[ScottShearer]

@luizhr 

Can you explain a little about what your Flow is doing?  I ask because I think it might be a timing issue.

[luizhr]

Basically I want to LOOKUP a variable in other List, (like Excel LOOKUP fuction). I thought about this "timing" issue, how could I solve that ? 

[ScottShearer]

@luizhr 

I'm not sure that it is a timing issue (don't know what other Flows may be running, etc.) but try putting a Delay action before your Get Items action.

[luizhr]

added 15 seconds, NO success 😞

[Zpemberton]

I believe if you put the delay right after the file creation you won't run into these issues.  From what I can see, you are attempting to grab file data as soon as it's created.  You may need to place the small delay after capturing the file creation in order to give some time for sharepoint to pick up the data.

[ScottShearer]

@luizhr 

I agree with @Zpemberton 

Originally, I suggested putting the delay before the Get Items but it couldn't hurt to place it immediately after the trigger.

[luizhr]

@ScottShearer and @Zpemberton I tried the suggestion, but NO success so far 😞 

I added 30 seconds of delay.. Do we need more ? 

[Zpemberton]

@luizhr Can you share the filter array in the flow builder so that I can see exactly what you are filtering?

[luizhr]

Sure @Zpemberton 

[Zpemberton]

I tested this on my end with no delay and I received the outputs with no problem, therefore I don't think it's a timing issue now.  One thing I did notice is that your second compare in the filter array is listed as 'CircuitA' instead of 'CircuitO' that is listed in all of your dynamic content.  Not sure if this is an issue or just a visual bug.  Try removing that second variable and re-adding it.

[luizhr]

@Zpemberton that was because of the screen zoom, there's no letter A in the end of word.

I'm thinking to rebuild the flow from zero and see what happens 😞 

[luizhr]

@Zpemberton  and @ScottShearer  I rebuild the flow, but still no success. Any other clue ? Is there any other specialist that you guys know that could help me on that ? I'd really appreciate. 🙂

[Zpemberton]

@luizhr Just to confirm, your get file properties action IS returning data on the first flow run, correct?

[luizhr]

@Zpemberton  Yes, no issue appears in this step. Only the following one (Filter Array)

[luizhr]

@Zpemberton & @ScottShearer  I just figure out by my own 🙂 

The output string from my variable was copying the "title". So the filter array output would always be empty for not matching.

Lesson learned : Avoid using the title collumn 

Thanks for the timing trying to help me 🙂

[Zpemberton]

@luizhr Glad you figured it out!  It's difficult sometimes to troubleshoot things like this without seeing all of the values.  Cheers to troubleshooting this!