web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How do I get parse the...
Power Automate
Unanswered

How do I get parse the output from Get Items?

(0) ShareShare
ReportReport
Posted on by 330

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?

 

 

 

Categories:
  • Rhiassuring Profile Picture
    8,692 Moderator on at

    Copy that entire output, and add a "Parse JSON" action. Click the "Generate from sample" button, and paste that in. Click done.. In the "Content", add the value from the Dynamic Content that, under the Get Items heading, says body. So it'll look like this, but where I have txtJSON, you'll have your body from your Get Items.

    Rhiassuring_0-1649717107954.png

     


    After you've done that, you'll magically have all of your fields under the "Parse JSON" field in your Dynamic Content.  When you add one of them, it'll turn into a "Apply to each" and will automatically loop through all instances of that value (ie, if you Get Items and have 70 records, and then choose "Expected Delivery", it will create a loop for you to go through each record of those 70 and review the Expected Delivery output.)

    Rhiassuring_1-1649717181176.png



    You can type in what you're looking for to shorten the very long list.

    Rhiassuring_2-1649717208596.png

     

     

    Cheers,

     

    Rhia





  • Thanura09 Profile Picture
    192 on at

    First Do as Rhia said and then take the select action from data operations, put the 'Body' of the JSON parse into From field and then in Map field, switch Map to text mode by clicking the icon at the end. you need to write an expression here, item().ExpectedDelivery.(column name in payload) then you'll have the array

    best wishes!

  • Spawn10 Profile Picture
    330 on at

    Hi Rhiassuring,

    Thanks for pointing me in this direction. This is what my flow currently looks like

    1.PNG

     

    With each looking like this...2.PNG

     

    When I test these, I am getting the error message that states 

        "The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array."

     

    Am I missing something? Any ideas why this is happening?

  • VictorIvanidze Profile Picture
    13,083 on at

    Try to add [ before first { and ] after last } in the Schema field.

  • Spawn10 Profile Picture
    330 on at

    When I add these to the schema, I get an "Action 'Parse_JSON' failed" error.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 377

#2
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 130

Last 30 days Overall leaderboard