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

(0) Share

Report

Posted on by luizhr

112

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

I have the same question (0)

All responses (16)

Answers (0)

ScottShearer 25,254 Most Valuable Professional on at

Like (0)

Report

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

@luizhr

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

Was this reply helpful? Yes No
luizhr 112 on at

Like (0)

Report

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

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 ?

Was this reply helpful? Yes No
ScottShearer 25,254 Most Valuable Professional on at

Like (0)

Report

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

@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.

Was this reply helpful? Yes No
luizhr 112 on at

Like (0)

Report

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

added 15 seconds, NO success 😞

Was this reply helpful? Yes No
Zpemberton 78 on at

Like (1)

Report

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

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.

Was this reply helpful? Yes No
ScottShearer 25,254 Most Valuable Professional on at

Like (1)

Report

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

@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.

Was this reply helpful? Yes No
luizhr 112 on at

Like (0)

Report

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

@ScottShearer and @Zpemberton I tried the suggestion, but NO success so far 😞
I added 30 seconds of delay.. Do we need more ?

Was this reply helpful? Yes No
Zpemberton 78 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
luizhr 112 on at

Like (0)

Report

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

Sure @Zpemberton

Was this reply helpful? Yes No
Zpemberton 78 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No