Power Platform Community Forum Thread Details

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:

General topics

Hi Guys,

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

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.!