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

Categories:

Building flows

All responses (16)

Answers (0)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@luizhr

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

Like
a
(0)

Report
Copy link

Link copied!

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 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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 112 on at

Like
a
(0)

Report
Copy link

Link copied!

added 15 seconds, NO success 😞
Zpemberton 78 on at

Like
a
(1)

Report
Copy link

Link copied!

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 25,331 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@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 112 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

Sure @Zpemberton
Zpemberton 78 on at

Like
a
(0)

Report
Copy link

Link copied!

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.