I am using list rows in a table action to get a row using filter query.
My excel contains more than 10000 rows.
I am using dynamic file path in this.
I have followed this article to get this workaround using microsoft graph : http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow
Here is my list rows action :
When I run this flow, it fails for the first time saying "Resource not found". But when flow is resubmitted it works perfectly fine and returns the row. After that flow never fails.
Now again if I change the file (file path is taken dynamically) it fails in the first run and works fine with second run onwards.
What am I doing wrong here?
Any help is appreciated.
P.S : If filter query is not applied then flow runs fine everytime. I believe it's an error with filter query.
Also, I can not use "Get a row" action due to some other limitations.