I had a flow that was working, but will no longer return all of the columns in a SharePoint list.
The Scope ID column is available in Dynamic content and its settings URL ends in Field=Scope.
But, when I try to run the flow and get the ID or value of the column using various connectors.
The trigger output does not contain Scope, even after deleting the trigger and recreating it.
{
"headers": {
"Transfer-Encoding": "chunked",
"Retry-After": "21600",
"Vary": "Origin,Accept-Encoding",
"X-NetworkStatistics": "0,525568,0,0,50287346,0,525568",
"X-SharePointHealthScore": "3",
"X-MS-SPConnector": "1",
"X-SP-SERVERSTATE": "ReadOnly=0",
"DATASERVICEVERSION": "3.0",
"SPClientServiceRequestDuration": "1013",
"SPRequestDuration": "1013",
"X-DataBoundary": "NONE",
"X-1DSCollectorUrl": "https://mobile.events.data.microsoft.com/OneCollector/1.0/",
"X-AriaCollectorURL": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",
"SPRequestGuid": "a7de7fe2-1056-4f5f-90a5-f84120f7f044",
"request-id": "a7de7fe2-1056-4f5f-90a5-f84120f7f044",
"MS-CV": "4n/ep1YQX0+QpfhBIPfwRA.0",
"Strict-Transport-Security": "max-age=31536000",
"X-FRAME-OPTIONS": "SAMEORIGIN",
"Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com teams.microsoftonline.cn *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",
"MicrosoftSharePointTeamServices": "16.0.0.23912",
"X-Content-Type-Options": "nosniff",
"X-MS-InvokeApp": "1; RequireReadOnly",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Cache-Control": "max-age=0, private",
"Date": "Thu, 27 Jul 2023 17:04:51 GMT",
"Location": "https://flow-apim-msmanaged-na-centralus-01.azure-apim.net/apim/sharepointonline/shared-sharepointonl-5eb43cd1-d4f1-4b3f-af12-1f25792409b4/datasets/https%253A%252F%252F ... /tables/c3278fbb-355f-4d02-8c1a-50d4a72348a2/onupdateditems?view=1507723d-8bae-40a1-94ec-ed58b97820ed&triggerstatecl=MTszO2MzMjc4ZmJiLTM1NWYtNGQwMi04YzFhLTUwZDRhNzIzNDhhMjs2MzgyNjA3NDI4ODE2MDAwMDA7MTc4ODkzNzI2MA%3d%3d",
"P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
"X-AspNet-Version": "4.0.30319",
"X-Powered-By": "ASP.NET",
"Content-Type": "application/json; charset=utf-8",
"Expires": "Wed, 12 Jul 2023 17:04:51 GMT",
"Last-Modified": "Thu, 27 Jul 2023 17:04:51 GMT",
"Content-Length": "2530"
},
"body": {
"@odata.etag": "\"5\"",
"ItemInternalId": "329",
"ID": 329,
"Title": "Archive NA-FFEM-QC-AZ PM Records",
"Lead": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 18,
"Value": "Janine White"
},
"Lead#Id": 18,
"Importance": 0,
"IsObjective": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "0 - No"
},
"IsObjective#Id": 1,
"Priority": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 2,
"Value": "2 - Medium"
},
"Priority#Id": 2,
"SImpact0": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "0 - No"
},
"SImpact0#Id": 1,
"CImpact": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 5,
"Value": "0 - None"
},
"CImpact#Id": 5,
"field_8": 0,
"field_9": 0,
"StatusLookup": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "1 - Idea"
},
"StatusLookup#Id": 1,
"field_5": 0,
"Notify": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 2,
"Value": "1 - Yes"
},
"Notify#Id": 2,
"Status_x003a__x0020_Status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Idea"
},
"Status_x003a__x0020_Status#Id": 1,
"Status_x003a__x0020_Status_x0020": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "1.00000000000000"
},
"Status_x003a__x0020_Status_x0020#Id": 1,
"Lead_x003a__x0020_Name": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 18,
"Value": " ... "
},
"Lead_x003a__x0020_Name#Id": 18,
"{Identifier}": "Lists%252fQuality%2bProjects%252f329_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "https:// ... /_layouts/15/listform.aspx?PageType=4&ListId=c3278fbb%2D355f%2D4d02%2D8c1a%2D50d4a72348a2&ID=329&ContentTypeID=0x010013C97D3A68BFC848A860A946FB92B6530004747C6512477D4192A44A134CBE652A",
"{Name}": "Archive NA-FFEM-QC-AZ PM Records",
"{FilenameWithExtension}": "Archive NA-FFEM-QC-AZ PM Records",
"{Path}": "Lists/Quality Projects/",
"{FullPath}": "Lists/Quality Projects/329_.000",
"{HasAttachments}": false,
"{VersionNumber}": "5.0",
"{TriggerWindowStartToken}": "MTszO2MzMjc4ZmJiLTM1NWYtNGQwMi04YzFhLTUwZDRhNzIzNDhhMjs2MzgyNjA3NDA4ODEzMDAwMDA7MTc4ODkzNzA2Mw==",
"{TriggerWindowEndToken}": "MTszO2MzMjc4ZmJiLTM1NWYtNGQwMi04YzFhLTUwZDRhNzIzNDhhMjs2MzgyNjA3NDI4ODE2MDAwMDA7MTc4ODkzNzI2MA=="
}
}
The HTTP request fails with the error, "The query to field 'Scope' is not valid. The $select query string must specify the target fields and the $expand query string must contains Scope.
clientRequestId: df57b37d-634c-4ed0-9415-0c322bb27100
serviceRequestId: a8b0caa0-806a-4000-141d-81499bfee7f4"
Using Get Item to get the record, then trying to read the field is also wrong.
