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

(1) Share

Report

Posted on by WorkingRicardo

757

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.

All responses (2)

Answers (1)

WorkingRicardo 757 on at

Like (0)

Report

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

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!
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report

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

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.