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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / [Solved] How to Parse ...
Power Automate
Answered

[Solved] How to Parse JSON as a array and update the excel/SharePoint ?

(0) ShareShare
ReportReport
Posted on by

Hi Community,

 

Greetings for the day,

 

I have the following JSON to parse as a array, loop through it and update the items into SharePoint list.

Is there any way to do this one ?

 

Thank you so much for your time,

Data required in single iteration of loop : EID, EMP Name, Job level ,Account etc.

 

 

[
 {
 "@odata.etag": "",
 "ItemInternalId": "2dc94879-049a-4042-85f5-f944ef03357e",
 "EID": "",
 "EMP Name": "",
 "Joblevel": "0",
 "Account Name": "",
 "Rev_x002e_ Region": "ANZ",
 "Country": "",
 "Capability/GIDC/Region": "",
 "Sub Program": "",
 "Work Performed by the Resource": "",
 "Lean and Automation Actions": "",
 "Action Date": "",
 "Action Type": "Exit",
 "Redeploy Category": "Redeployment",
 "Sending PPMC ID": "123456",
 "PPMC End Date": "",
 "Receiving PPMC ID": "",
 "PPMC Start Date": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "d4869179-bc92-43db-a872-443fafbfb6cf",
 "EID": "",
 "EMP Name": "",
 "Joblevel": "",
 "Account Name": "",
 "Rev_x002e_ Region": "",
 "Country": "",
 "Capability/GIDC/Region": "",
 "Sub Program": "",
 "Work Performed by the Resource": "",
 "Lean and Automation Actions": "",
 "Action Date": "",
 "Action Type": "Redeploy",
 "Redeploy Category": "",
 "Sending PPMC ID": "",
 "PPMC End Date": "",
 "Receiving PPMC ID": "",
 "PPMC Start Date": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "9e2161b4-19a9-4605-af06-f6cfe9056117",
 "EID": "it should be of 8 digit number",
 "EMP Name": "",
 "Joblevel": "",
 "Account Name": "",
 "Rev_x002e_ Region": "",
 "Country": "",
 "Capability/GIDC/Region": "",
 "Sub Program": "",
 "Work Performed by the Resource": "",
 "Lean and Automation Actions": "",
 "Action Date": "",
 "Action Type": "",
 "Redeploy Category": "",
 "Sending PPMC ID": "",
 "PPMC End Date": "",
 "Receiving PPMC ID": "",
 "PPMC Start Date": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "83e66d5e-5103-4a27-a3d7-2538985f600c",
 "EID": "",
 "EMP Name": "",
 "Joblevel": "",
 "Account Name": "",
 "Rev_x002e_ Region": "",
 "Country": "",
 "Capability/GIDC/Region": "",
 "Sub Program": "",
 "Work Performed by the Resource": "",
 "Lean and Automation Actions": "",
 "Action Date": "",
 "Action Type": "",
 "Redeploy Category": "",
 "Sending PPMC ID": "this should be 8 digit number",
 "PPMC End Date": "it should be a date",
 "Receiving PPMC ID": "same like column n",
 "PPMC Start Date": " it should be date only"
 }
]

 

 

 

Thanks again,

 

Manoj

Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    on at

    Hi Guys,

    Got the solution, it is pretty straight forward we can directly loop through because it's a already and array,

     

    ManojR_0-1627139762209.png

    Was trying to get json output of list rows from present in table and parsing it, so just updated the schema with following

    {
     "type": "object",
     "properties": {
     "@@odata.etag": {
     "type": "string"
     },
     "ItemInternalId": {
     "type": "string"
     },
     "EID": {
     "type": "string"
     },
     "EMP Name": {
     "type": "string"
     },
     "Joblevel": {
     "type": "string"
     },
     "Account Name": {
     "type": "string"
     },
     "Rev_x002e_ Region": {
     "type": "string"
     },
     "Country": {
     "type": "string"
     },
     "Capability/GIDC/Region": {
     "type": "string"
     },
     "Sub Program": {
     "type": "string"
     },
     "Work Performed by the Resource": {
     "type": "string"
     },
     "Lean and Automation Actions": {
     "type": "string"
     },
     "Action Date": {
     "type": "string"
     },
     "Action Type": {
     "type": "string"
     },
     "Redeploy Category": {
     "type": "string"
     },
     "Sending PPMC ID": {
     "type": "string"
     },
     "PPMC End Date": {
     "type": "string"
     },
     "Receiving PPMC ID": {
     "type": "string"
     },
     "PPMC Start Date": {
     "type": "string"
     }
     }
    }

    template,

     

     

     

     

    I was not able to find to delete this post so thought put answer of this one and close it off,

     

     

    Thank you.!

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard