Forum Discussion
Netrelemo
Helper IV
Helper IVHow do I trap a function error?
I'm using PowerQuery to try get the contents of a list on 1,000 plus SharePoint sites. So I have retrieved the list of site URLs and constructed the list URL, and now want to get the contents o...
You need an otherwise to go with your try
aSource = try OData.Feed(SiteURL , null, [Implementation="2.0"]) otherwise nullIf it is the Removed Other Columns step that generates the error, you could add a step to add a column with Table.RowCount( ) after aSource, and then filter out any rows where the table does not have >=1 rows.
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeYou need an otherwise to go with your try
aSource = try OData.Feed(SiteURL , null, [Implementation="2.0"]) otherwise null
If it is the Removed Other Columns step that generates the error, you could add a step to add a column with Table.RowCount( ) after aSource, and then filter out any rows where the table does not have >=1 rows.
Pat