cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Excel connector: List rows present in a table

Hello,

 

The action "List rows present in a table" from the Excel connector is giving us some headaches.

 

We use a simple odata filter. Most of the time it works correctly, but often (when the load is higher) it returns an empty result while it shouldn't. The exact same connector (and filter) does return results a few minutes earlier or later.

 

The connector should at least return an error instead of an empty result.

 

The excel is about 1MB, the table we fetch contains 900 rows and 40 columns. Pagination is enabled in the connector.

 

Aantekening 2020-01-14 110240.jpg

5 REPLIES 5
Highlighted
Super User II
Super User II

Re: Excel connector: List rows present in a table

HI @bart_vermeersch 

 

The Excel connector is finicky in some areas and you're finding one. You're doing the right steps, but 1mb is not "that" big to run into issues. Indeed it should return an error, and that's an issue.

 

Just to check, when it returns zero, the ProjectID matches with data in the Excel correct? Can you check a run history that it returned 0 and see if, for some reason, the ProjectID had a strange or undefined value in it or a value that could not be in the excel? 

 

Would SharePoint be an option to store and manage this data? Migration would be easy and SharePoint is much more stable to deal with growing volumes of data. I understand that teams want to work in Excel, but it's just a suggestion. 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Regular Visitor

Re: Excel connector: List rows present in a table

Hello Manuel,

 

SharePoint is not an option (the flow syncs data from SharePoint to an Excel). They are both needed in the current business process.

 

We have checked, the projectID matches the Excel. The exact same odata filter often does return the correct result.

 

Bart

Highlighted
Super User II
Super User II

Re: Excel connector: List rows present in a table

Hi @bart_vermeersch 

 

If it matches then it's the connector acting up. You need to build probably a safeguard while running so that, when it's zero, trigger a warning so that someone can check the history and, if all is ok, run it again. 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Dual Super User III
Dual Super User III

Re: Excel connector: List rows present in a table

Hi @bart_vermeersch 

 

Can you disable the pagination setting and add 2000 to the top count field the in the list rows from excel action? 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Regular Visitor

Re: Excel connector: List rows present in a table

Hello @yashag2255 

 

Disabling pagination and adding 2000 to the top count didn't help, it still returns wrong results under heavy load 😞

 

The returned results did change slightly from

{ "value":[]}

to

{ "@odata.context":"https://excelonline-ne.azconn-ne.p.azurewebsites.net/$metadata#drives('xxx')/Files('xxx')/Tables('xx...",

"value":[]}

 

Thank you anyway!

 

 

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,233)