Continue query by unauthorized or try and catch?

[benjamin183]

Hi everbody, 

I have SharePoint List with two columns title and url. The url column has a link to other site collections. I build up query taht loops through each item and call the listdata.svc SharePoint Service. For example one item has the url https://mysharepointurl the function will build

https://mysharepointurl/_vti_bin/Listdata.svc/MYSharePointlist (that list is on ever site collection with same name and id). The Resault will look like that 

Title	Url	Column 1	Column 2
Test 1	hhttps://mysharepointurl1	Test	Test
Test 2	https://mysharepointurl2	Test	Test

My Problem are currently the permission in sharepoint. Every user has read acces on the list that stores the url but not on the site collection. If the user is executing the query and has for one site collection no permissions, the query will break and ask for crendentials instead to load all the other columns where the user has enough permissions to acces the listdatasvc on the site collection.

Is there a possiblity to handle that so that Power Query is continuing with the query on the sites where the user has accees. Only workaorund i see is to give list item permissions. If the user do not see the entry in the list it works, but SharePoint and liste item permission are quiet complicated. 

I just need a solution if you get 401 skip that row show an error dosen't matter just continue with rest

Kind regards

Benjamin

[v-yuezhe-msft]

Hi @benjamin183,

In Power Query, you can use try otherwise to ignore error 401 and continue to execute mashup differently, there is a similar thread for your reference: https://social.technet.microsoft.com/Forums/en-US/d0816891-6351-4d80-9fdc-1401e08a5f1d/how-to-ignore... .

However, I am afraid try otherwise doesn't help in your sceanrio. The problem is related to SharePoint permissions, there is not much we can do from Power Query side.

Thanks,
Lydia Zhang