Sharepoint Input Error ('list' object has no attribute 'columns')

[T0masz]

Hello, 

I've g a flow to work on Sharepoint data, used Sharepoint Input Tool but get error "'list' object has no attribute 'columns'" when trying to input my list. Tried to limit number of columns by creating a very limited view, up to the moment when my view had just one column (ID) but that wouldn't work.

I can input Sharepoint lists from other sites. 

Please advise on my issue.

Tomasz 

[BS_THE_ANALYST]

@T0masz if you can read from some sites but not others, is it a permissions related issue? Does the list have data in (not sure if it'd kick up a fuss if it didn't)?

Could you create a new list on that site, pop some dummy data in, and try to read the new list in?

All the best,

BS

[T0masz]

BS

I don't think it's a permission issue: I can import other lists form this site. Also when I put SharePoint Input Tool I can see list of list (including the problematic one) and views, so the Tool can read this information from the SharePoint but gets error when attempts to get actual data. It's something more to do with this particular list I think. It's got around 22k records and ~150columns on this list.

[hroderick-thr]

I'm getting the same error switching to sharepoint input 2.7.0  it works fine on 2.5.0

[T0masz]

I installed 2.5 but got same error. I've red now that this tool limitation is 5k lines and my list is 22k. Hroderick-thr, how big is your list, please?

[hroderick-thr · Accepted solution]

My list is over 5000, about 7500.  

FYI: I installed 2.6.0 and it WORKED OK!

Do historical patterns repeat? Long ago you skipped the odd number Windows versions because they broke things and only installed the even versions because they fixed what was broken. https://news.ycombinator.com/item?id=28851844