I have two SharePoint lists, one which houses orders, and a second list that houses all the items in an order. In my Flow, I want to get the value of a column and build an array when there are more than one item in the second list. I am using a "Get Items" to retrieve all the orders in the second list, based on the order number from the parent list. So far, the output of my "Get Items" looks like this...
{"statusCode":200,"headers":{"Transfer-Encoding":"chunked","Vary":"Origin,Accept-Encoding","X-SharePointHealthScore":"3","X-MS-SPConnector":"1","X-SP-SERVERSTATE":"ReadOnly=0","DATASERVICEVERSION":"3.0","SPClientServiceRequestDuration":"80","SPRequestGuid":"ac125aa0-9849-4054-a276-3356084baacf","request-id":"ac125aa0-9849-4054-a276-3356084baacf","MS-CV":"oFoSrEmYVECidjNWCEuqzw.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 *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com;","MicrosoftSharePointTeamServices":"16.0.0.22323","X-Content-Type-Options":"nosniff","X-MS-InvokeApp":"1; RequireReadOnly","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","x-ms-apihub-obo":"true","Cache-Control":"max-age=0, private","Date":"Mon, 11 Apr 2022 19:23:29 GMT","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":"Sun, 27 Mar 2022 19:23:29 GMT","Last-Modified":"Mon, 11 Apr 2022 19:23:29 GMT","Content-Length":"7901"},"body":{"value":[{"@odata.etag":"\"2\"","ItemInternalId":"2833","ID":2833,"Title":"line 1","LineId":1.0,"Created":"2022-04-11T18:36:40Z","PO":"0987","ItemValue":1.0,"PODocs":"0987","ExpectedDelivery":"2022-04-22","PODate":"2022-04-12","POValue":10.0,"ModelNumber":"Mod1","Author":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|svc-hw_apps@my.com","DisplayName":"svc-HW_Apps","Email":"svc-HW_Apps@my.com","Picture":"https://my.sharepoint.com/sites/MySite/_layouts/15/UserPhoto.aspx?Size=L&AccountName=svc-HW_Apps@my.com","Department":null,"JobTitle":null},"Author#Claims":"i:0#.f|membership|svc-hw_apps@my.com","Modified":"2022-04-11T18:37:37Z","Editor":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|svc-hw_apps@my.com","DisplayName":"svc-HW_Apps","Email":"svc-HW_Apps@my.com","Picture":"https://my.sharepoint.com/sites/MySite/_layouts/15/UserPhoto.aspx?Size=L&AccountName=svc-HW_Apps@my.com","Department":null,"JobTitle":null},"Editor#Claims":"i:0#.f|membership|svc-hw_apps@my.com","Dept":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"DVE"},"Dept#Id":0,"Status":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Requested"},"Status#Id":0,"GUID0":"288e8e9b-4298-4726-9cfe-95136fe24edb","Qty":1.0,"{Identifier}":"Lists%252fPending%2bInventory%252f2833_.000","{IsFolder}":false,"{Thumbnail}":{"Large":null,"Medium":null,"Small":null},"{Link}":"https://my.sharepoint.com/sites/MySite/_layouts/15/listform.aspx?PageType=4&ListId=da777myc%2Daf1b%2D4cbb%2D9fc2%2D258f0a2f210f&ID=2833&ContentTypeID=0x010023FA0985C238A84D9213ED9E4994A0770001my5FEFDCBDC54B8D4D31B03BECE5D3","{Name}":"line 1","{FilenameWithExtension}":"line 1","{Path}":"Lists/Pending Inventory/","{FullPath}":"Lists/Pending Inventory/2833_.000","{HasAttachments}":false,"{VersionNumber}":"2.0"},{"@odata.etag":"\"2\"","ItemInternalId":"2834","ID":2834,"Title":"line 2","LineId":2.0,"Created":"2022-04-11T18:36:40Z","PO":"0987","ItemValue":1.0,"PODocs":"0987","ExpectedDelivery":"2022-04-20","PODate":"2022-04-12","POValue":10.0,"ModelNumber":"MOD 2","Author":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|svc-hw_apps@my.com","DisplayName":"svc-HW_Apps","Email":"svc-HW_Apps@my.com","Picture":"https://my.sharepoint.com/sites/MySite/_layouts/15/UserPhoto.aspx?Size=L&AccountName=svc-HW_Apps@my.com","Department":null,"JobTitle":null},"Author#Claims":"i:0#.f|membership|svc-hw_apps@my.com","Modified":"2022-04-11T18:37:36Z","Editor":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|svc-hw_apps@my.com","DisplayName":"svc-HW_Apps","Email":"svc-HW_Apps@my.com","Picture":"https://my.sharepoint.com/sites/MySite/_layouts/15/UserPhoto.aspx?Size=L&AccountName=svc-HW_Apps@my.com","Department":null,"JobTitle":null},"Editor#Claims":"i:0#.f|membership|svc-hw_apps@my.com","Dept":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"DVE"},"Dept#Id":0,"Status":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Requested"},"Status#Id":0,"GUID0":"095f9727-6f54-45f5-8c70-b2315aabf4fc","Qty":1.0,"{Identifier}":"Lists%252fPending%2bInventory%252f2834_.000","{IsFolder}":false,"{Thumbnail}":{"Large":null,"Medium":null,"Small":null},"{Link}":"https://my.sharepoint.com/sites/MySite/_layouts/15/listform.aspx?PageType=4&ListId=da777fbc%2Daf1b%2D4cbb%2D9fc2%2D258f0a2f210f&ID=2834&ContentTypeID=0x010023FA0985C238A84D9213ED9E4994A0770001FB5FEFDCBDC54B8D4D31B03BECE5D3","{Name}":"line 2","{FilenameWithExtension}":"line 2","{Path}":"Lists/Pending Inventory/","{FullPath}":"Lists/Pending Inventory/2834_.000","{HasAttachments}":false,"{VersionNumber}":"2.0"},{"@odata.etag":"\"1\"","ItemInternalId":"2835","ID":2835,"Title":"line 1","LineId":1.0,"Created":"2022-04-11T18:37:35Z","PO":"0987","ItemValue":1.0,"PODocs":"0987","ExpectedDelivery":"2022-04-22","PODate":"2022-04-12","POValue":10.0,"ModelNumber":"Mod1","Author":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|svc-hw_apps@my.com","DisplayName":"svc-HW_Apps","Email":"svc-HW_Apps@my.com","Picture":"https://my.sharepoint.com/sites/MySite/_layouts/15/UserPhoto.aspx?Size=L&AccountName=svc-HW_Apps@my.com","Department":null,"JobTitle":null},"Author#Claims":"i:0#.f|membership|svc-hw_apps@my.com","Modified":"2022-04-11T18:37:35Z","Editor":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|svc-hw_apps@my.com","DisplayName":"svc-HW_Apps","Email":"svc-HW_Apps@my.com","Picture":"https://my.sharepoint.com/sites/MySite/_layouts/15/UserPhoto.aspx?Size=L&AccountName=svc-HW_Apps@my.com","Department":null,"JobTitle":null},"Editor#Claims":"i:0#.f|membership|svc-hw_apps@my.com","Dept":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"DVE"},"Dept#Id":0,"Status":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Requested"},"Status#Id":0,"GUID0":"288e8e9b-4298-4726-9cfe-95136fe24edb","Qty":1.0,"{Identifier}":"Lists%252fPending%2bInventory%252f2835_.000","{IsFolder}":false,"{Thumbnail}":{"Large":null,"Medium":null,"Small":null},"{Link}":"https://my.sharepoint.com/sites/MySite/_layouts/15/listform.aspx?PageType=4&ListId=da777fbc%2Daf1b%2D4cbb%2D9fc2%2D258f0a2f210f&ID=2835&ContentTypeID=0x010023FA0985C238A84D9213ED9E4994A0770001FB5FEFDCBDC54B8D4D31B03BECE5D3","{Name}":"line 1","{FilenameWithExtension}":"line 1","{Path}":"Lists/Pending Inventory/","{FullPath}":"Lists/Pending Inventory/2835_.000","{HasAttachments}":false,"{VersionNumber}":"1.0"},{"@odata.etag":"\"1\"","ItemInternalId":"2836","ID":2836,"Title":"line 2","LineId":2.0,"Created":"2022-04-11T18:37:36Z","PO":"0987","ItemValue":1.0,"PODocs":"0987","ExpectedDelivery":"2022-04-20","PODate":"2022-04-12","POValue":10.0,"ModelNumber":"MOD 2","Author":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|svc-hw_apps@my.com","DisplayName":"svc-HW_Apps","Email":"svc-HW_Apps@my.com","Picture":"https://my.sharepoint.com/sites/MySite/_layouts/15/UserPhoto.aspx?Size=L&AccountName=svc-HW_Apps@my.com","Department":null,"JobTitle":null},"Author#Claims":"i:0#.f|membership|svc-hw_apps@my.com","Modified":"2022-04-11T18:37:36Z","Editor":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|svc-hw_apps@my.com","DisplayName":"svc-HW_Apps","Email":"svc-HW_Apps@my.com","Picture":"https://my.sharepoint.com/sites/MySite/_layouts/15/UserPhoto.aspx?Size=L&AccountName=svc-HW_Apps@my.com","Department":null,"JobTitle":null},"Editor#Claims":"i:0#.f|membership|svc-hw_apps@my.com","Dept":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"DVE"},"Dept#Id":0,"Status":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Requested"},"Status#Id":0,"GUID0":"095f9727-6f54-45f5-8c70-b2315aabf4fc","Qty":1.0,"{Identifier}":"Lists%252fPending%2bInventory%252f2836_.000","{IsFolder}":false,"{Thumbnail}":{"Large":null,"Medium":null,"Small":null},"{Link}":"https://my.sharepoint.com/sites/MySite/_layouts/15/listform.aspx?PageType=4&ListId=da777fbc%2Daf1b%2D4cbb%2D9fc2%2D258f0a2f210f&ID=2836&ContentTypeID=0x010023FA0985C238A84D9213ED9E4994A0770001FB5FEFDCBDC54B8D4D31B03BECE5D3","{Name}":"line 2","{FilenameWithExtension}":"line 2","{Path}":"Lists/Pending Inventory/","{FullPath}":"Lists/Pending Inventory/2836_.000","{HasAttachments}":false,"{VersionNumber}":"1.0"}]}}
At this point, I want to build an array of all the data in the 'ExpectedDelivery' column. How do I do this?