Excel: List rows present in a table + filter query error

(1) Share

Report

Posted on by WorkingRicardo

876

So I'm having issues with my Excel tablle. I have the Filter Query set to:

ArtNumber eq '@{triggerOutputs()?['body/Article1']}'

And this should return basically this filtered Excel table:

Captura de pantalla 2024-07-08 120920.png

But for some reason, only the Spain and Portugal rows show up. Italy is nowhere to be seen. And it always happens with Italy, no matter what ArtNumber I input. So.... What is going on? This screws up my whole flow 😞

appreciate your input in advance.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @WorkingRicardo

Pls try increasing the pagination for "List rows present in a table" action. Click (..) & select "Settings" from sub menu:

Toggle on "Pagination" switch & enter 5000 in "Threshold" textbox:

Click "Done" to save the changes & retest the flow.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
WorkingRicardo 876 on at

Like (0)

Report
Copy link

Link copied!

hey @ManishSolanki ty for your reply.
Before adding this it was randomly fixed but I think this will help with the error not ocurring anytime soon. Thanks!

Was this reply helpful? Yes No