I have created a flow to Create New Item In the Common Data Service when New Item is created in SharePoint List.
SharePoint List consists of Lookup columns which are pointing to different lists. My account has an access to all of the lists which are Lookups.
I get this error when Flow is trying to query data from Other Sharepoint list which are Lookups:
Headers
{ "Pragma": "no-cache", "x-ms-request-id": "5a46363c-56b0-4994-b680-8d5d07a7c615", "Cache-Control": "no-cache", "Date": "Sun, 02 Apr 2017 16:34:56 GMT", "Set-Cookie": "ARRAffinity=6f87b92787b7f3b45b17b2f525a670883ff8d34bcd24b2d0eecfa033b8e3e94f;Path=/;Domain=127.0.0.1", "Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0", "X-AspNet-Version": "4.0.30319", "X-Powered-By": "ASP.NET", "Content-Length": "2254", "Content-Type": "application/json; charset=utf-8", "Expires": "-1" }
Body:
{ "status": 401, "message": "", "source": "https://advancedcorrection.sharepoint.com/sites/development/_api/web/lists/getbytitle('Facility')/Items?$expand=State,RNM,Program_x0020_Consultant,Primary_x0020_Pharmacy,Backup_x0020_Pharmacy_x0020_1,Backup_x0020_Pharmacy_x0020_2,Backup_x0020_Pharmacy_x0020_3,Practitioner_x0020_1st_x0020_cal,Practitioner_x0020_2nd_x0020_cal,Practitioner_x0020_3rd_x0020_cal,RNM_x0020_2nd_x0020_call,RNM_x0020_3rd_x0020_call,Mental_x0020_Health_x0020_1st_x0,Mental_x0020_Health_x0020_2nd_x0,Unavailable_x0020_Practitioner,Regional_x0020_Medical_x0020_Dir,Author,Editor&$select=*,State/Title,RNM/Title,Program_x0020_Consultant/Title,Primary_x0020_Pharmacy/Title,Backup_x0020_Pharmacy_x0020_1/Title,Backup_x0020_Pharmacy_x0020_2/Title,Backup_x0020_Pharmacy_x0020_3/Title,Practitioner_x0020_1st_x0020_cal/Full_x0020_Name,Practitioner_x0020_2nd_x0020_cal/Full_x0020_Name,Practitioner_x0020_3rd_x0020_cal/Full_x0020_Name,RNM_x0020_2nd_x0020_call/Title,RNM_x0020_3rd_x0020_call/Title,Mental_x0020_Health_x0020_1st_x0/Full_x0020_Name,Mental_x0020_Health_x0020_2nd_x0/Full_x0020_Name,Unavailable_x0020_Practitioner/Full_x0020_Name,Regional_x0020_Medical_x0020_Dir/Full_x0020_Name,Author/Name,Editor/Name,Practitioner_x0020_1st_x0020_cal/Cell_x0020_phone_x0020__x0023_,Practitioner_x0020_1st_x0020_cal/Other_x0020__x0023_,Practitioner_x0020_2nd_x0020_cal/Cell_x0020_phone_x0020__x0023_,Practitioner_x0020_2nd_x0020_cal/Other_x0020__x0023_,Practitioner_x0020_2nd_x0020_cal/Home_x0020_Ph_x0023_,Practitioner_x0020_3rd_x0020_cal/Cell_x0020_phone_x0020__x0023_,Practitioner_x0020_3rd_x0020_cal/Other_x0020__x0023_,Practitioner_x0020_3rd_x0020_cal/Home_x0020_Ph_x0023_,RNM_x0020_2nd_x0020_call/RNM_x0027_s_x0020_phone_x0020_nu,Mental_x0020_Health_x0020_1st_x0/Cell_x0020_phone_x0020__x0023_,RNM_x0020_3rd_x0020_call/RNM_x0027_s_x0020_phone_x0020_nu,RNM/RNM_x0027_s_x0020_phone_x0020_nu,Mental_x0020_Health_x0020_2nd_x0/Cell_x0020_phone_x0020__x0023_,Practitioner_x0020_1st_x0020_cal/Ptitle,Practitioner_x0020_2nd_x0020_cal/Ptitle,Practitioner_x0020_3rd_x0020_cal/Ptitle,Mental_x0020_Health_x0020_1st_x0/Ptitle,Mental_x0020_Health_x0020_2nd_x0/Ptitle,Program_x0020_Consultant/PC_x0027_s_x0020_phone_x0020_num&$orderby=ID%20desc&$top=1", "errors": [] }
You see that is trying to expend