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 / [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 Microsoft Employee

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
    Microsoft Employee 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 60 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 54

#3
Expiscornovus Profile Picture

Expiscornovus 47 Most Valuable Professional

Last 30 days Overall leaderboard