cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Action 'Apply_to_each' failed

Hi,

 

I'd be needing your expertise regarding my concern.

 

I have a flow based from this link. When I run the flow, I'm getting this error on the 'Apply to each' action:

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['value']' is of type 'Null'. The result must be a valid array.

error4.PNG

Kindly advise. Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Action 'Apply_to_each' failed

Hello @kristinamariz 

After the parse JSON action you could do something like this:

parseJson.png

1) For each "result" item: 

outputs('Parse_JSON')?['d']?['results']

2) Get the comments value:

items('apply_to_each')?['comments']

 

Hope it helps!

Ferran 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

10 REPLIES 10
Highlighted
Super User II
Super User II

Re: Action 'Apply_to_each' failed

Hello @kristinamariz 

It seems you are trying to evaluate an empty array (NULL). Could you display the output values of the "Send HTTP Request..." and "Parse JSON" actions?

Regards,

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!
Highlighted
Helper II
Helper II

Re: Action 'Apply_to_each' failed

Hi @fchopo, there are value that are null because the user didn't input the details but on the Parse, I have this:

 

{
    "type": "object",
    "properties": {
        "value": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "Comment": {
                        "type": [
                            "string",
                            "null"
                        ]
                    }
                },
                "required": [
                    "Comment"
                ]
            }
        }
    }
}

 

 

I added "type": ["string","null"]. Here's a bit of the result of Parse JSON:

 

 

{
  "d": {
    "results": [
      {
        "__metadata": {
          "id": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3",
          "uri": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3",
          "type": "SP.ListItemVersion"
        },
        "CreatedBy": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3/CreatedBy"
          }
        },
        "Fields": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3/Fields"
          }
        },
        "FileVersion": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3/FileVersion"
          }
        },
        "Created": "2020-08-04T11:44:07",
        "IsCurrentVersion": true,
        "VersionId": 4096,
        "VersionLabel": "8.0",
        "ContentTypeId": {
          "__metadata": {
            "type": "SP.ContentTypeId"
          },
          "StringValue": "0x0100EC80A015AF11544CBF624F41C03D4C42"
        },
        "Title": "ITC",
        "OData__x005f_ModerationComments": null,
        "File_x005f_x0020_x005f_Type": null,
        "ComplianceAssetId": null,
        "IncrementNumber": 11,
        "Requester": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "IssueNo": "Legal-0011",
        "DateRequested": "2020-07-23T16:00:00Z",
        "RequestType": "Contract Review",
        "Entity": null,
        "OtherEntity": null,
        "CounterpartyType": "Variation",
        "CounterpartyName": "Eastern Telecom",
        "CounterpartyContactName": "Knicka Somera",
        "CounterpartyContactNum": "09288377655",
        "CounterpartyContactEmail": "knicka@eastern.com",
        "CounterpartyContactLegal": null,
        "CounterpartyContactedB4": "Don't Know",
        "CounterpartyContactedYES": null,
        "CounterpartyChecks": "Don't know",
        "CounterpartyChecksYES": null,
        "ContractCommencement": "Annual",
        "ContractExpiry": "2021-07-23T16:00:00Z",
        "ContractDescription": "ISP for Tenant",
        "ContractGUSRole": "NA",
        "ContractCounterpartyOb": "Coordination",
        "ContractTotalValue": "188284673",
        "ContractCurrency": "PHP",
        "ContractAgreedPay": null,
        "ContractAttachment": "0",
        "ContractServiceCredit": "No",
        "ContractServiceCreditYES": null,
        "ContractGUSTerm": null,
        "ContractCounterpartTerm": null,
        "ContractAccessConfi": "No",
        "ContractAccessConfiYES": null,
        "ContractPartyPersonalAttach": "0",
        "ContractMemorandumAttach": "0",
        "ContractOtherParties": "No",
        "ContractOtherPartiesYES": null,
        "Comments": null,
        "CommentsStatements": null,
        "AuthorisationTick": null,
        "RequestingPerson": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "RequestingDAte": "2020-07-23T16:00:00Z",
        "LineManager": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 34,
          "LookupValue": "Manager Name",
          "Email": "Manager Email"
        },
        "LineManagerApproval": "Approved",
        "LegalAssignee": null,
        "Status": "Pending",
        "AutoTicket": {
          "__metadata": {
            "type": "SP.FieldUrlValue"
          },
          "Description": "Stage 1",
          "Url": "***_layouts/15/wrkstat.aspx?List=a0793150-5fb7-4d3d-a2ca-7e0a42f9acb5&WorkflowInstanceName=a18dd51b-1d8f-4d1e-b702-f218338f11f7"
        },
        "CounterpartGDPR": null,
        "LineMDateApprove": null,
        "LegalApproval": null,
        "LegalDateApprove": null,
        "Comment": "comment 3",
        "ID": 11,
        "Modified": "2020-08-04T11:44:07Z",
        "Author": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },

 

 

Here's a part of the result of Send HTTP request:

 

{
  "d": {
    "results": [
      {
        "__metadata": {
          "id": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3",
          "uri": "***/_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3",
          "type": "SP.ListItemVersion"
        },
        "CreatedBy": {
          "__deferred": {
            "uri": "***/_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3/CreatedBy"
          }
        },
        "Fields": {
          "__deferred": {
            "uri": "***/_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3/Fields"
          }
        },
        "FileVersion": {
          "__deferred": {
            "uri": "***/_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3/FileVersion"
          }
        },
        "Created": "2020-08-04T11:44:07",
        "IsCurrentVersion": true,
        "VersionId": 4096,
        "VersionLabel": "8.0",
        "ContentTypeId": {
          "__metadata": {
            "type": "SP.ContentTypeId"
          },
          "StringValue": "0x0100EC80A015AF11544CBF624F41C03D4C42"
        },
        "Title": "ITC",
        "OData__x005f_ModerationComments": null,
        "File_x005f_x0020_x005f_Type": null,
        "ComplianceAssetId": null,
        "IncrementNumber": 11,
        "Requester": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User name",
          "Email": "user@email"
        },
        "IssueNo": "Legal-0011",
        "DateRequested": "2020-07-23T16:00:00Z",
        "RequestType": "Contract Review",
        "Entity": null,
        "OtherEntity": null,
        "CounterpartyType": "Variation",
        "CounterpartyName": "Eastern Telecom",
        "CounterpartyContactName": "Knicka Somera",
        "CounterpartyContactNum": "09288377655",
        "CounterpartyContactEmail": "knicka@eastern.com",
        "CounterpartyContactLegal": null,
        "CounterpartyContactedB4": "Don't Know",
        "CounterpartyContactedYES": null,
        "CounterpartyChecks": "Don't know",
        "CounterpartyChecksYES": null,
        "ContractCommencement": "Annual",
        "ContractExpiry": "2021-07-23T16:00:00Z",
        "ContractDescription": "ISP for Tenant",
        "ContractGUSRole": "NA",
        "ContractCounterpartyOb": "Coordination",
        "ContractTotalValue": "188284673",
        "ContractCurrency": "PHP",
        "ContractAgreedPay": null,
        "ContractAttachment": "0",
        "ContractServiceCredit": "No",
        "ContractServiceCreditYES": null,
        "ContractGUSTerm": null,
        "ContractCounterpartTerm": null,
        "ContractAccessConfi": "No",
        "ContractAccessConfiYES": null,
        "ContractPartyPersonalAttach": "0",
        "ContractMemorandumAttach": "0",
        "ContractOtherParties": "No",
        "ContractOtherPartiesYES": null,
        "Comments": null,
        "CommentsStatements": null,
        "AuthorisationTick": null,
        "RequestingPerson": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User name",
          "Email": "user@email"
        },
        "RequestingDAte": "2020-07-23T16:00:00Z",
        "LineManager": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 34,
          "LookupValue": "Manager Approval",
          "Email": "manager email"
        },
        "LineManagerApproval": "Approved",
        "LegalAssignee": null,
        "Status": "Pending",
        "AutoTicket": {
          "__metadata": {
            "type": "SP.FieldUrlValue"
          },
          "Description": "Stage 1",
          "Url": "***/_layouts/15/wrkstat.aspx?List=a0793150-5fb7-4d3d-a2ca-7e0a42f9acb5&WorkflowInstanceName=a18dd51b-1d8f-4d1e-b702-f218338f11f7"
        },
        "CounterpartGDPR": null,
        "LineMDateApprove": null,
        "LegalApproval": null,
        "LegalDateApprove": null,
        "Comment": "comment 3",
        "ID": 11,
        "Modified": "2020-08-04T11:44:07Z",
        "Author": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User name",
          "Email": "user@email"
        },

 

 

I am hopeful these help. Kindly advise if you need further info. Thank you!


Highlighted
Community Support
Community Support

Re: Action 'Apply_to_each' failed

Hi @kristinamariz ,

 

As @fchopo  said, you need to check if the Body output of the Parse JSON is null. And you could add a Condition before the Apply to each to check if the output is null, if yes, do noting, if not, do the Apply to each part.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Helper II
Helper II

Re: Action 'Apply_to_each' failed

Hi @v-alzhan-msft, thanks for the advice. This will be difficult because some fields may need to have blank based on user's details.

 

What I'm trying to do is to display the comment based on the procedure on this link. Would like to know your thoughts on this.

 

Thanks!  

Highlighted
Community Support
Community Support

Re: Action 'Apply_to_each' failed

Hi @kristinamariz ,

 

You should share the full Value output from the Parse JSON action.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Helper II
Helper II

Re: Action 'Apply_to_each' failed

Hi @v-alzhan-msft, here's the full value output from Parse JSON:

{
  "d": {
    "results": [
      {
        "__metadata": {
          "id": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3",
          "uri": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3",
          "type": "SP.ListItemVersion"
        },
        "CreatedBy": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3/CreatedBy"
          }
        },
        "Fields": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3/Fields"
          }
        },
        "FileVersion": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersionddbe5dbf-65a4-4639-8853-ba8f4ad303c3/FileVersion"
          }
        },
        "Created": "2020-08-04T11:44:07",
        "IsCurrentVersion": true,
        "VersionId": 4096,
        "VersionLabel": "8.0",
        "ContentTypeId": {
          "__metadata": {
            "type": "SP.ContentTypeId"
          },
          "StringValue": "0x0100EC80A015AF11544CBF624F41C03D4C42"
        },
        "Title": "ITC",
        "OData__x005f_ModerationComments": null,
        "File_x005f_x0020_x005f_Type": null,
        "ComplianceAssetId": null,
        "IncrementNumber": 11,
        "Requester": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "IssueNo": "Legal-0011",
        "DateRequested": "2020-07-23T16:00:00Z",
        "RequestType": "Contract Review",
        "Entity": null,
        "OtherEntity": null,
        "CounterpartyType": "Variation",
        "CounterpartyName": "Eastern Telecom",
        "CounterpartyContactName": "Knicka Somera",
        "CounterpartyContactNum": "09288377655",
        "CounterpartyContactEmail": "knicka@eastern.com",
        "CounterpartyContactLegal": null,
        "CounterpartyContactedB4": "Don't Know",
        "CounterpartyContactedYES": null,
        "CounterpartyChecks": "Don't know",
        "CounterpartyChecksYES": null,
        "ContractCommencement": "Annual",
        "ContractExpiry": "2021-07-23T16:00:00Z",
        "ContractDescription": "ISP for Tenant",
        "ContractGUSRole": "NA",
        "ContractCounterpartyOb": "Coordination",
        "ContractTotalValue": "188284673",
        "ContractCurrency": "PHP",
        "ContractAgreedPay": null,
        "ContractAttachment": "0",
        "ContractServiceCredit": "No",
        "ContractServiceCreditYES": null,
        "ContractGUSTerm": null,
        "ContractCounterpartTerm": null,
        "ContractAccessConfi": "No",
        "ContractAccessConfiYES": null,
        "ContractPartyPersonalAttach": "0",
        "ContractMemorandumAttach": "0",
        "ContractOtherParties": "No",
        "ContractOtherPartiesYES": null,
        "Comments": null,
        "CommentsStatements": null,
        "AuthorisationTick": null,
        "RequestingPerson": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "RequestingDAte": "2020-07-23T16:00:00Z",
        "LineManager": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 34,
          "LookupValue": "Manager Name",
          "Email": "Manager Email"
        },
        "LineManagerApproval": "Approved",
        "LegalAssignee": null,
        "Status": "Pending",
        "AutoTicket": {
          "__metadata": {
            "type": "SP.FieldUrlValue"
          },
          "Description": "Stage 1",
          "Url": "***_layouts/15/wrkstat.aspx?List=a0793150-5fb7-4d3d-a2ca-7e0a42f9acb5&WorkflowInstanceName=a18dd51b-1d8f-4d1e-b702-f218338f11f7"
        },
        "CounterpartGDPR": null,
        "LineMDateApprove": null,
        "LegalApproval": null,
        "LegalDateApprove": null,
        "Comment": "comment 3",
        "ID": 11,
        "Modified": "2020-08-04T11:44:07Z",
        "Author": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "Editor": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "OData__x005f_HasCopyDestinations": null,
        "OData__x005f_CopySource": null,
        "owshiddenversion": 13,
        "WorkflowVersion": 1,
        "OData__x005f_UIVersion": 4096,
        "OData__x005f_UIVersionString": "8.0",
        "Attachments": true,
        "OData__x005f_ModerationStatus": 0,
        "InstanceID": null,
        "Order": 1100,
        "GUID": "f22dfd1d-24f0-4c5f-8b22-6528c0e91455",
        "WorkflowInstanceID": null,
        "FileRef": "/site/Lists/Legal Request/11_.000",
        "FileDirRef": "/site/Lists/Legal Request",
        "Last_x005f_x0020_x005f_Modified": "2020-07-24T14:08:45Z",
        "Created_x005f_x0020_x005f_Date": "2020-07-24T14:08:45Z",
        "FSObjType": "0",
        "SortBehavior": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": "0"
        },
        "FileLeafRef": "11_.000",
        "UniqueId": "abc3d345-ee69-4850-8adf-352cd51a17a4",
        "SyncClientId": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": null
        },
        "ProgId": "",
        "ScopeId": "{41E3778F-1824-4A4D-8B81-5C39B65BAB3D}",
        "MetaInfo": "",
        "OData__x005f_Level": 1,
        "OData__x005f_IsCurrentVersion": true,
        "ItemChildCount": "0",
        "FolderChildCount": "0",
        "Restricted": "",
        "OriginatorId": "",
        "NoExecute": "0",
        "ContentVersion": "0",
        "OData__x005f_ComplianceFlags": "",
        "OData__x005f_ComplianceTag": "",
        "OData__x005f_ComplianceTagWrittenTime": "",
        "OData__x005f_ComplianceTagUserId": "",
        "AccessPolicy": "",
        "OData__x005f_VirusStatus": "",
        "OData__x005f_VirusVendorID": "",
        "OData__x005f_VirusInfo": "",
        "AppAuthor": null,
        "AppEditor": null,
        "SMTotalSize": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 7910,
          "LookupValue": ""
        },
        "SMLastModifiedDate": "2020-08-04T11:44:07Z",
        "SMTotalFileStreamSize": "0",
        "SMTotalFileCount": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 0,
          "LookupValue": ""
        },
        "OData__x005f_CommentFlags": "",
        "OData__x005f_CommentCount": ""
      },
      {
        "__metadata": {
          "id": "***_api/SP.ListItemVersion3c2b4a3e-7257-47ee-8f71-8dfe8e94a80e",
          "uri": "***_api/SP.ListItemVersion3c2b4a3e-7257-47ee-8f71-8dfe8e94a80e",
          "type": "SP.ListItemVersion"
        },
        "CreatedBy": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion3c2b4a3e-7257-47ee-8f71-8dfe8e94a80e/CreatedBy"
          }
        },
        "Fields": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion3c2b4a3e-7257-47ee-8f71-8dfe8e94a80e/Fields"
          }
        },
        "FileVersion": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion3c2b4a3e-7257-47ee-8f71-8dfe8e94a80e/FileVersion"
          }
        },
        "Created": "2020-08-04T09:06:55",
        "IsCurrentVersion": false,
        "VersionId": 3584,
        "VersionLabel": "7.0",
        "ContentTypeId": {
          "__metadata": {
            "type": "SP.ContentTypeId"
          },
          "StringValue": "0x0100EC80A015AF11544CBF624F41C03D4C42"
        },
        "Title": "ITC",
        "OData__x005f_ModerationComments": null,
        "File_x005f_x0020_x005f_Type": null,
        "ComplianceAssetId": null,
        "IncrementNumber": 11,
        "Requester": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "IssueNo": "Legal-0011",
        "DateRequested": "2020-07-23T16:00:00Z",
        "RequestType": "Contract Review",
        "Entity": null,
        "OtherEntity": null,
        "CounterpartyType": "Variation",
        "CounterpartyName": "Eastern Telecom",
        "CounterpartyContactName": "Knicka Somera",
        "CounterpartyContactNum": "09288377655",
        "CounterpartyContactEmail": "knicka@eastern.com",
        "CounterpartyContactLegal": null,
        "CounterpartyContactedB4": "Don't Know",
        "CounterpartyContactedYES": null,
        "CounterpartyChecks": "Don't know",
        "CounterpartyChecksYES": null,
        "ContractCommencement": "Annual",
        "ContractExpiry": "2021-07-23T16:00:00Z",
        "ContractDescription": "ISP for Tenant",
        "ContractGUSRole": "NA",
        "ContractCounterpartyOb": "Coordination",
        "ContractTotalValue": "188284673",
        "ContractCurrency": "PHP",
        "ContractAgreedPay": null,
        "ContractAttachment": "0",
        "ContractServiceCredit": "No",
        "ContractServiceCreditYES": null,
        "ContractGUSTerm": null,
        "ContractCounterpartTerm": null,
        "ContractAccessConfi": "No",
        "ContractAccessConfiYES": null,
        "ContractPartyPersonalAttach": "0",
        "ContractMemorandumAttach": "0",
        "ContractOtherParties": "No",
        "ContractOtherPartiesYES": null,
        "Comments": null,
        "CommentsStatements": null,
        "AuthorisationTick": null,
        "RequestingPerson": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "RequestingDAte": "2020-07-23T16:00:00Z",
        "LineManager": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 34,
          "LookupValue": "Manager Name",
          "Email": "Manager Email"
        },
        "LineManagerApproval": "Approved",
        "LegalAssignee": null,
        "Status": "Pending",
        "AutoTicket": {
          "__metadata": {
            "type": "SP.FieldUrlValue"
          },
          "Description": "Stage 1",
          "Url": "***_layouts/15/wrkstat.aspx?List=a0793150-5fb7-4d3d-a2ca-7e0a42f9acb5&WorkflowInstanceName=a18dd51b-1d8f-4d1e-b702-f218338f11f7"
        },
        "CounterpartGDPR": null,
        "LineMDateApprove": null,
        "LegalApproval": null,
        "LegalDateApprove": null,
        "Comment": "comment 2",
        "ID": 11,
        "Modified": "2020-08-04T09:06:55Z",
        "Author": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "Editor": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "OData__x005f_HasCopyDestinations": null,
        "OData__x005f_CopySource": null,
        "owshiddenversion": 12,
        "WorkflowVersion": 1,
        "OData__x005f_UIVersion": 3584,
        "OData__x005f_UIVersionString": "7.0",
        "Attachments": true,
        "OData__x005f_ModerationStatus": 0,
        "InstanceID": null,
        "Order": 1100,
        "GUID": "f22dfd1d-24f0-4c5f-8b22-6528c0e91455",
        "WorkflowInstanceID": null,
        "FileRef": "/site/Lists/Legal Request/11_.000",
        "FileDirRef": "/site/Lists/Legal Request",
        "Last_x005f_x0020_x005f_Modified": "2020-07-24T14:08:45Z",
        "Created_x005f_x0020_x005f_Date": "2020-07-24T14:08:45Z",
        "FSObjType": "0",
        "SortBehavior": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": "0"
        },
        "FileLeafRef": "11_.000",
        "UniqueId": "abc3d345-ee69-4850-8adf-352cd51a17a4",
        "SyncClientId": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": null
        },
        "ProgId": "",
        "ScopeId": "{41E3778F-1824-4A4D-8B81-5C39B65BAB3D}",
        "MetaInfo": "",
        "OData__x005f_Level": 1,
        "OData__x005f_IsCurrentVersion": false,
        "ItemChildCount": "0",
        "FolderChildCount": "0",
        "Restricted": "",
        "OriginatorId": "",
        "NoExecute": "0",
        "ContentVersion": "0",
        "OData__x005f_ComplianceFlags": "",
        "OData__x005f_ComplianceTag": "",
        "OData__x005f_ComplianceTagWrittenTime": "",
        "OData__x005f_ComplianceTagUserId": "",
        "AccessPolicy": "",
        "OData__x005f_VirusStatus": "",
        "OData__x005f_VirusVendorID": "",
        "OData__x005f_VirusInfo": "",
        "AppAuthor": null,
        "AppEditor": null,
        "SMTotalSize": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 7910,
          "LookupValue": ""
        },
        "SMLastModifiedDate": "2020-08-04T11:44:07Z",
        "SMTotalFileStreamSize": "0",
        "SMTotalFileCount": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 0,
          "LookupValue": ""
        },
        "OData__x005f_CommentFlags": "",
        "OData__x005f_CommentCount": ""
      },
      {
        "__metadata": {
          "id": "***_api/SP.ListItemVersion895eef4a-31b3-4401-a05f-64360800686d",
          "uri": "***_api/SP.ListItemVersion895eef4a-31b3-4401-a05f-64360800686d",
          "type": "SP.ListItemVersion"
        },
        "CreatedBy": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion895eef4a-31b3-4401-a05f-64360800686d/CreatedBy"
          }
        },
        "Fields": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion895eef4a-31b3-4401-a05f-64360800686d/Fields"
          }
        },
        "FileVersion": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion895eef4a-31b3-4401-a05f-64360800686d/FileVersion"
          }
        },
        "Created": "2020-08-04T09:06:36",
        "IsCurrentVersion": false,
        "VersionId": 3072,
        "VersionLabel": "6.0",
        "ContentTypeId": {
          "__metadata": {
            "type": "SP.ContentTypeId"
          },
          "StringValue": "0x0100EC80A015AF11544CBF624F41C03D4C42"
        },
        "Title": "ITC",
        "OData__x005f_ModerationComments": null,
        "File_x005f_x0020_x005f_Type": null,
        "ComplianceAssetId": null,
        "IncrementNumber": 11,
        "Requester": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "IssueNo": "Legal-0011",
        "DateRequested": "2020-07-23T16:00:00Z",
        "RequestType": "Contract Review",
        "Entity": null,
        "OtherEntity": null,
        "CounterpartyType": "Variation",
        "CounterpartyName": "Eastern Telecom",
        "CounterpartyContactName": "Knicka Somera",
        "CounterpartyContactNum": "09288377655",
        "CounterpartyContactEmail": "knicka@eastern.com",
        "CounterpartyContactLegal": null,
        "CounterpartyContactedB4": "Don't Know",
        "CounterpartyContactedYES": null,
        "CounterpartyChecks": "Don't know",
        "CounterpartyChecksYES": null,
        "ContractCommencement": "Annual",
        "ContractExpiry": "2021-07-23T16:00:00Z",
        "ContractDescription": "ISP for Tenant",
        "ContractGUSRole": "NA",
        "ContractCounterpartyOb": "Coordination",
        "ContractTotalValue": "188284673",
        "ContractCurrency": "PHP",
        "ContractAgreedPay": null,
        "ContractAttachment": "0",
        "ContractServiceCredit": "No",
        "ContractServiceCreditYES": null,
        "ContractGUSTerm": null,
        "ContractCounterpartTerm": null,
        "ContractAccessConfi": "No",
        "ContractAccessConfiYES": null,
        "ContractPartyPersonalAttach": "0",
        "ContractMemorandumAttach": "0",
        "ContractOtherParties": "No",
        "ContractOtherPartiesYES": null,
        "Comments": null,
        "CommentsStatements": null,
        "AuthorisationTick": null,
        "RequestingPerson": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "RequestingDAte": "2020-07-23T16:00:00Z",
        "LineManager": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 34,
          "LookupValue": "Manager Name",
          "Email": "Manager Email"
        },
        "LineManagerApproval": "Approved",
        "LegalAssignee": null,
        "Status": "Pending",
        "AutoTicket": {
          "__metadata": {
            "type": "SP.FieldUrlValue"
          },
          "Description": "Stage 1",
          "Url": "***_layouts/15/wrkstat.aspx?List=a0793150-5fb7-4d3d-a2ca-7e0a42f9acb5&WorkflowInstanceName=a18dd51b-1d8f-4d1e-b702-f218338f11f7"
        },
        "CounterpartGDPR": null,
        "LineMDateApprove": null,
        "LegalApproval": null,
        "LegalDateApprove": null,
        "Comment": "comment 1",
        "ID": 11,
        "Modified": "2020-08-04T09:06:36Z",
        "Author": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "Editor": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "OData__x005f_HasCopyDestinations": null,
        "OData__x005f_CopySource": null,
        "owshiddenversion": 11,
        "WorkflowVersion": 1,
        "OData__x005f_UIVersion": 3072,
        "OData__x005f_UIVersionString": "6.0",
        "Attachments": true,
        "OData__x005f_ModerationStatus": 0,
        "InstanceID": null,
        "Order": 1100,
        "GUID": "f22dfd1d-24f0-4c5f-8b22-6528c0e91455",
        "WorkflowInstanceID": null,
        "FileRef": "/site/Lists/Legal Request/11_.000",
        "FileDirRef": "/site/Lists/Legal Request",
        "Last_x005f_x0020_x005f_Modified": "2020-07-24T14:08:45Z",
        "Created_x005f_x0020_x005f_Date": "2020-07-24T14:08:45Z",
        "FSObjType": "0",
        "SortBehavior": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": "0"
        },
        "FileLeafRef": "11_.000",
        "UniqueId": "abc3d345-ee69-4850-8adf-352cd51a17a4",
        "SyncClientId": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": null
        },
        "ProgId": "",
        "ScopeId": "{41E3778F-1824-4A4D-8B81-5C39B65BAB3D}",
        "MetaInfo": "",
        "OData__x005f_Level": 1,
        "OData__x005f_IsCurrentVersion": false,
        "ItemChildCount": "0",
        "FolderChildCount": "0",
        "Restricted": "",
        "OriginatorId": "",
        "NoExecute": "0",
        "ContentVersion": "0",
        "OData__x005f_ComplianceFlags": "",
        "OData__x005f_ComplianceTag": "",
        "OData__x005f_ComplianceTagWrittenTime": "",
        "OData__x005f_ComplianceTagUserId": "",
        "AccessPolicy": "",
        "OData__x005f_VirusStatus": "",
        "OData__x005f_VirusVendorID": "",
        "OData__x005f_VirusInfo": "",
        "AppAuthor": null,
        "AppEditor": null,
        "SMTotalSize": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 7910,
          "LookupValue": ""
        },
        "SMLastModifiedDate": "2020-08-04T11:44:07Z",
        "SMTotalFileStreamSize": "0",
        "SMTotalFileCount": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 0,
          "LookupValue": ""
        },
        "OData__x005f_CommentFlags": "",
        "OData__x005f_CommentCount": ""
      },
      {
        "__metadata": {
          "id": "***_api/SP.ListItemVersion124df07f-addc-49ac-aeb6-5f8a9cf0a434",
          "uri": "***_api/SP.ListItemVersion124df07f-addc-49ac-aeb6-5f8a9cf0a434",
          "type": "SP.ListItemVersion"
        },
        "CreatedBy": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion124df07f-addc-49ac-aeb6-5f8a9cf0a434/CreatedBy"
          }
        },
        "Fields": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion124df07f-addc-49ac-aeb6-5f8a9cf0a434/Fields"
          }
        },
        "FileVersion": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion124df07f-addc-49ac-aeb6-5f8a9cf0a434/FileVersion"
          }
        },
        "Created": "2020-07-29T07:56:48",
        "IsCurrentVersion": false,
        "VersionId": 2560,
        "VersionLabel": "5.0",
        "ContentTypeId": {
          "__metadata": {
            "type": "SP.ContentTypeId"
          },
          "StringValue": "0x0100EC80A015AF11544CBF624F41C03D4C42"
        },
        "Title": "ITC",
        "OData__x005f_ModerationComments": null,
        "File_x005f_x0020_x005f_Type": null,
        "ComplianceAssetId": null,
        "IncrementNumber": 11,
        "Requester": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "IssueNo": "Legal-0011",
        "DateRequested": "2020-07-23T16:00:00Z",
        "RequestType": "Contract Review",
        "Entity": null,
        "OtherEntity": null,
        "CounterpartyType": "Variation",
        "CounterpartyName": "Eastern Telecom",
        "CounterpartyContactName": "Knicka Somera",
        "CounterpartyContactNum": "09288377655",
        "CounterpartyContactEmail": "knicka@eastern.com",
        "CounterpartyContactLegal": null,
        "CounterpartyContactedB4": "Don't Know",
        "CounterpartyContactedYES": null,
        "CounterpartyChecks": "Don't know",
        "CounterpartyChecksYES": null,
        "ContractCommencement": "Annual",
        "ContractExpiry": "2021-07-23T16:00:00Z",
        "ContractDescription": "ISP for Tenant",
        "ContractGUSRole": "NA",
        "ContractCounterpartyOb": "Coordination",
        "ContractTotalValue": "188284673",
        "ContractCurrency": "PHP",
        "ContractAgreedPay": null,
        "ContractAttachment": "0",
        "ContractServiceCredit": "No",
        "ContractServiceCreditYES": null,
        "ContractGUSTerm": null,
        "ContractCounterpartTerm": null,
        "ContractAccessConfi": "No",
        "ContractAccessConfiYES": null,
        "ContractPartyPersonalAttach": "0",
        "ContractMemorandumAttach": "0",
        "ContractOtherParties": "No",
        "ContractOtherPartiesYES": null,
        "Comments": null,
        "CommentsStatements": null,
        "AuthorisationTick": null,
        "RequestingPerson": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "RequestingDAte": "2020-07-23T16:00:00Z",
        "LineManager": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 34,
          "LookupValue": "Manager Name",
          "Email": "Manager Email"
        },
        "LineManagerApproval": "Approved",
        "LegalAssignee": null,
        "Status": "Pending",
        "AutoTicket": {
          "__metadata": {
            "type": "SP.FieldUrlValue"
          },
          "Description": "Stage 1",
          "Url": "***_layouts/15/wrkstat.aspx?List=a0793150-5fb7-4d3d-a2ca-7e0a42f9acb5&WorkflowInstanceName=a18dd51b-1d8f-4d1e-b702-f218338f11f7"
        },
        "CounterpartGDPR": null,
        "LineMDateApprove": null,
        "LegalApproval": null,
        "LegalDateApprove": null,
        "Comment": null,
        "ID": 11,
        "Modified": "2020-07-29T07:56:48Z",
        "Author": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "Editor": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "OData__x005f_HasCopyDestinations": null,
        "OData__x005f_CopySource": null,
        "owshiddenversion": 10,
        "WorkflowVersion": 1,
        "OData__x005f_UIVersion": 2560,
        "OData__x005f_UIVersionString": "5.0",
        "Attachments": true,
        "OData__x005f_ModerationStatus": 0,
        "InstanceID": null,
        "Order": 1100,
        "GUID": "f22dfd1d-24f0-4c5f-8b22-6528c0e91455",
        "WorkflowInstanceID": null,
        "FileRef": "/site/Lists/Legal Request/11_.000",
        "FileDirRef": "/site/Lists/Legal Request",
        "Last_x005f_x0020_x005f_Modified": "2020-07-24T14:08:45Z",
        "Created_x005f_x0020_x005f_Date": "2020-07-24T14:08:45Z",
        "FSObjType": "0",
        "SortBehavior": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": "0"
        },
        "FileLeafRef": "11_.000",
        "UniqueId": "abc3d345-ee69-4850-8adf-352cd51a17a4",
        "SyncClientId": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": null
        },
        "ProgId": "",
        "ScopeId": "{41E3778F-1824-4A4D-8B81-5C39B65BAB3D}",
        "MetaInfo": "",
        "OData__x005f_Level": 1,
        "OData__x005f_IsCurrentVersion": false,
        "ItemChildCount": "0",
        "FolderChildCount": "0",
        "Restricted": "",
        "OriginatorId": "",
        "NoExecute": "0",
        "ContentVersion": "0",
        "OData__x005f_ComplianceFlags": "",
        "OData__x005f_ComplianceTag": "",
        "OData__x005f_ComplianceTagWrittenTime": "",
        "OData__x005f_ComplianceTagUserId": "",
        "AccessPolicy": "",
        "OData__x005f_VirusStatus": "",
        "OData__x005f_VirusVendorID": "",
        "OData__x005f_VirusInfo": "",
        "AppAuthor": null,
        "AppEditor": null,
        "SMTotalSize": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 7910,
          "LookupValue": ""
        },
        "SMLastModifiedDate": "2020-08-04T11:44:07Z",
        "SMTotalFileStreamSize": "0",
        "SMTotalFileCount": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 0,
          "LookupValue": ""
        },
        "OData__x005f_CommentFlags": "",
        "OData__x005f_CommentCount": ""
      },
      {
        "__metadata": {
          "id": "***_api/SP.ListItemVersion7b1fbdd9-7842-47a9-9b60-e445003d65db",
          "uri": "***_api/SP.ListItemVersion7b1fbdd9-7842-47a9-9b60-e445003d65db",
          "type": "SP.ListItemVersion"
        },
        "CreatedBy": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion7b1fbdd9-7842-47a9-9b60-e445003d65db/CreatedBy"
          }
        },
        "Fields": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion7b1fbdd9-7842-47a9-9b60-e445003d65db/Fields"
          }
        },
        "FileVersion": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion7b1fbdd9-7842-47a9-9b60-e445003d65db/FileVersion"
          }
        },
        "Created": "2020-07-29T06:02:49",
        "IsCurrentVersion": false,
        "VersionId": 2048,
        "VersionLabel": "4.0",
        "ContentTypeId": {
          "__metadata": {
            "type": "SP.ContentTypeId"
          },
          "StringValue": "0x0100EC80A015AF11544CBF624F41C03D4C42"
        },
        "Title": "ITC",
        "OData__x005f_ModerationComments": null,
        "File_x005f_x0020_x005f_Type": null,
        "ComplianceAssetId": null,
        "IncrementNumber": 11,
        "Requester": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "IssueNo": "Legal-0011",
        "DateRequested": "2020-07-23T16:00:00Z",
        "RequestType": "Contract Review",
        "Entity": null,
        "OtherEntity": null,
        "CounterpartyType": "Variation",
        "CounterpartyName": "Eastern Telecom",
        "CounterpartyContactName": "Knicka Somera",
        "CounterpartyContactNum": "09288377655",
        "CounterpartyContactEmail": "knicka@eastern.com",
        "CounterpartyContactLegal": null,
        "CounterpartyContactedB4": "Don't Know",
        "CounterpartyContactedYES": null,
        "CounterpartyChecks": "Don't know",
        "CounterpartyChecksYES": null,
        "ContractCommencement": "Annual",
        "ContractExpiry": "2021-07-23T16:00:00Z",
        "ContractDescription": "ISP for Tenant",
        "ContractGUSRole": "NA",
        "ContractCounterpartyOb": "Coordination",
        "ContractTotalValue": "188284673",
        "ContractCurrency": "PHP",
        "ContractAgreedPay": null,
        "ContractAttachment": "0",
        "ContractServiceCredit": "No",
        "ContractServiceCreditYES": null,
        "ContractGUSTerm": null,
        "ContractCounterpartTerm": null,
        "ContractAccessConfi": "No",
        "ContractAccessConfiYES": null,
        "ContractPartyPersonalAttach": "0",
        "ContractMemorandumAttach": "0",
        "ContractOtherParties": "No",
        "ContractOtherPartiesYES": null,
        "Comments": null,
        "CommentsStatements": null,
        "AuthorisationTick": null,
        "RequestingPerson": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "RequestingDAte": "2020-07-23T16:00:00Z",
        "LineManager": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 34,
          "LookupValue": "Manager Name",
          "Email": "Manager Email"
        },
        "LineManagerApproval": "Approved",
        "LegalAssignee": null,
        "Status": "Pending",
        "AutoTicket": {
          "__metadata": {
            "type": "SP.FieldUrlValue"
          },
          "Description": "Stage 1",
          "Url": "***_layouts/15/wrkstat.aspx?List=a0793150-5fb7-4d3d-a2ca-7e0a42f9acb5&WorkflowInstanceName=a18dd51b-1d8f-4d1e-b702-f218338f11f7"
        },
        "CounterpartGDPR": null,
        "LineMDateApprove": null,
        "LegalApproval": null,
        "LegalDateApprove": null,
        "Comment": null,
        "ID": 11,
        "Modified": "2020-07-29T06:02:49Z",
        "Author": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "Editor": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "OData__x005f_HasCopyDestinations": null,
        "OData__x005f_CopySource": null,
        "owshiddenversion": 9,
        "WorkflowVersion": 1,
        "OData__x005f_UIVersion": 2048,
        "OData__x005f_UIVersionString": "4.0",
        "Attachments": true,
        "OData__x005f_ModerationStatus": 0,
        "InstanceID": null,
        "Order": 1100,
        "GUID": "f22dfd1d-24f0-4c5f-8b22-6528c0e91455",
        "WorkflowInstanceID": null,
        "FileRef": "/site/Lists/Legal Request/11_.000",
        "FileDirRef": "/site/Lists/Legal Request",
        "Last_x005f_x0020_x005f_Modified": "2020-07-24T14:08:45Z",
        "Created_x005f_x0020_x005f_Date": "2020-07-24T14:08:45Z",
        "FSObjType": "0",
        "SortBehavior": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": "0"
        },
        "FileLeafRef": "11_.000",
        "UniqueId": "abc3d345-ee69-4850-8adf-352cd51a17a4",
        "SyncClientId": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": null
        },
        "ProgId": "",
        "ScopeId": "{41E3778F-1824-4A4D-8B81-5C39B65BAB3D}",
        "MetaInfo": "",
        "OData__x005f_Level": 1,
        "OData__x005f_IsCurrentVersion": false,
        "ItemChildCount": "0",
        "FolderChildCount": "0",
        "Restricted": "",
        "OriginatorId": "",
        "NoExecute": "0",
        "ContentVersion": "0",
        "OData__x005f_ComplianceFlags": "",
        "OData__x005f_ComplianceTag": "",
        "OData__x005f_ComplianceTagWrittenTime": "",
        "OData__x005f_ComplianceTagUserId": "",
        "AccessPolicy": "",
        "OData__x005f_VirusStatus": "",
        "OData__x005f_VirusVendorID": "",
        "OData__x005f_VirusInfo": "",
        "AppAuthor": null,
        "AppEditor": null,
        "SMTotalSize": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 7910,
          "LookupValue": ""
        },
        "SMLastModifiedDate": "2020-08-04T11:44:07Z",
        "SMTotalFileStreamSize": "0",
        "SMTotalFileCount": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 0,
          "LookupValue": ""
        },
        "OData__x005f_CommentFlags": "",
        "OData__x005f_CommentCount": ""
      },
      {
        "__metadata": {
          "id": "***_api/SP.ListItemVersiona21af580-a055-40ac-9407-41739a16203d",
          "uri": "***_api/SP.ListItemVersiona21af580-a055-40ac-9407-41739a16203d",
          "type": "SP.ListItemVersion"
        },
        "CreatedBy": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersiona21af580-a055-40ac-9407-41739a16203d/CreatedBy"
          }
        },
        "Fields": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersiona21af580-a055-40ac-9407-41739a16203d/Fields"
          }
        },
        "FileVersion": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersiona21af580-a055-40ac-9407-41739a16203d/FileVersion"
          }
        },
        "Created": "2020-07-29T05:51:34",
        "IsCurrentVersion": false,
        "VersionId": 1536,
        "VersionLabel": "3.0",
        "ContentTypeId": {
          "__metadata": {
            "type": "SP.ContentTypeId"
          },
          "StringValue": "0x0100EC80A015AF11544CBF624F41C03D4C42"
        },
        "Title": "ITC",
        "OData__x005f_ModerationComments": null,
        "File_x005f_x0020_x005f_Type": null,
        "ComplianceAssetId": null,
        "IncrementNumber": 11,
        "Requester": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "IssueNo": "Legal-0011",
        "DateRequested": "2020-07-23T16:00:00Z",
        "RequestType": "Contract Review",
        "Entity": null,
        "OtherEntity": null,
        "CounterpartyType": "Variation",
        "CounterpartyName": "Eastern Telecom",
        "CounterpartyContactName": "Knicka Somera",
        "CounterpartyContactNum": "09288377655",
        "CounterpartyContactEmail": "knicka@eastern.com",
        "CounterpartyContactLegal": null,
        "CounterpartyContactedB4": "Don't Know",
        "CounterpartyContactedYES": null,
        "CounterpartyChecks": "Don't know",
        "CounterpartyChecksYES": null,
        "ContractCommencement": "Annual",
        "ContractExpiry": "2021-07-23T16:00:00Z",
        "ContractDescription": "ISP for Tenant",
        "ContractGUSRole": "NA",
        "ContractCounterpartyOb": "Coordination",
        "ContractTotalValue": "188284673",
        "ContractCurrency": "PHP",
        "ContractAgreedPay": null,
        "ContractAttachment": "0",
        "ContractServiceCredit": "No",
        "ContractServiceCreditYES": null,
        "ContractGUSTerm": null,
        "ContractCounterpartTerm": null,
        "ContractAccessConfi": "No",
        "ContractAccessConfiYES": null,
        "ContractPartyPersonalAttach": "0",
        "ContractMemorandumAttach": "0",
        "ContractOtherParties": "No",
        "ContractOtherPartiesYES": null,
        "Comments": null,
        "CommentsStatements": null,
        "AuthorisationTick": null,
        "RequestingPerson": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "RequestingDAte": "2020-07-23T16:00:00Z",
        "LineManager": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 34,
          "LookupValue": "Manager Name",
          "Email": "Manager Email"
        },
        "LineManagerApproval": "Approved",
        "LegalAssignee": null,
        "Status": "Pending",
        "AutoTicket": {
          "__metadata": {
            "type": "SP.FieldUrlValue"
          },
          "Description": "Stage 1",
          "Url": "***_layouts/15/wrkstat.aspx?List=a0793150-5fb7-4d3d-a2ca-7e0a42f9acb5&WorkflowInstanceName=a18dd51b-1d8f-4d1e-b702-f218338f11f7"
        },
        "CounterpartGDPR": null,
        "LineMDateApprove": null,
        "LegalApproval": null,
        "LegalDateApprove": null,
        "Comment": null,
        "ID": 11,
        "Modified": "2020-07-29T05:51:34Z",
        "Author": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "Editor": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "OData__x005f_HasCopyDestinations": null,
        "OData__x005f_CopySource": null,
        "owshiddenversion": 8,
        "WorkflowVersion": 1,
        "OData__x005f_UIVersion": 1536,
        "OData__x005f_UIVersionString": "3.0",
        "Attachments": true,
        "OData__x005f_ModerationStatus": 0,
        "InstanceID": null,
        "Order": 1100,
        "GUID": "f22dfd1d-24f0-4c5f-8b22-6528c0e91455",
        "WorkflowInstanceID": null,
        "FileRef": "/site/Lists/Legal Request/11_.000",
        "FileDirRef": "/site/Lists/Legal Request",
        "Last_x005f_x0020_x005f_Modified": "2020-07-24T14:08:45Z",
        "Created_x005f_x0020_x005f_Date": "2020-07-24T14:08:45Z",
        "FSObjType": "0",
        "SortBehavior": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": "0"
        },
        "FileLeafRef": "11_.000",
        "UniqueId": "abc3d345-ee69-4850-8adf-352cd51a17a4",
        "SyncClientId": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": null
        },
        "ProgId": "",
        "ScopeId": "{41E3778F-1824-4A4D-8B81-5C39B65BAB3D}",
        "MetaInfo": "",
        "OData__x005f_Level": 1,
        "OData__x005f_IsCurrentVersion": false,
        "ItemChildCount": "0",
        "FolderChildCount": "0",
        "Restricted": "",
        "OriginatorId": "",
        "NoExecute": "0",
        "ContentVersion": "0",
        "OData__x005f_ComplianceFlags": "",
        "OData__x005f_ComplianceTag": "",
        "OData__x005f_ComplianceTagWrittenTime": "",
        "OData__x005f_ComplianceTagUserId": "",
        "AccessPolicy": "",
        "OData__x005f_VirusStatus": "",
        "OData__x005f_VirusVendorID": "",
        "OData__x005f_VirusInfo": "",
        "AppAuthor": null,
        "AppEditor": null,
        "SMTotalSize": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 7910,
          "LookupValue": ""
        },
        "SMLastModifiedDate": "2020-08-04T11:44:07Z",
        "SMTotalFileStreamSize": "0",
        "SMTotalFileCount": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 0,
          "LookupValue": ""
        },
        "OData__x005f_CommentFlags": "",
        "OData__x005f_CommentCount": ""
      },
      {
        "__metadata": {
          "id": "***_api/SP.ListItemVersion11877e18-1988-49bc-9222-4c8a4e8f695d",
          "uri": "***_api/SP.ListItemVersion11877e18-1988-49bc-9222-4c8a4e8f695d",
          "type": "SP.ListItemVersion"
        },
        "CreatedBy": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion11877e18-1988-49bc-9222-4c8a4e8f695d/CreatedBy"
          }
        },
        "Fields": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion11877e18-1988-49bc-9222-4c8a4e8f695d/Fields"
          }
        },
        "FileVersion": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion11877e18-1988-49bc-9222-4c8a4e8f695d/FileVersion"
          }
        },
        "Created": "2020-07-29T05:51:24",
        "IsCurrentVersion": false,
        "VersionId": 1024,
        "VersionLabel": "2.0",
        "ContentTypeId": {
          "__metadata": {
            "type": "SP.ContentTypeId"
          },
          "StringValue": "0x0100EC80A015AF11544CBF624F41C03D4C42"
        },
        "Title": "ITC",
        "OData__x005f_ModerationComments": null,
        "File_x005f_x0020_x005f_Type": null,
        "ComplianceAssetId": null,
        "IncrementNumber": 11,
        "Requester": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "IssueNo": "Legal-0011",
        "DateRequested": "2020-07-23T16:00:00Z",
        "RequestType": "Contract Review",
        "Entity": null,
        "OtherEntity": null,
        "CounterpartyType": "Variation",
        "CounterpartyName": "Eastern Telecom",
        "CounterpartyContactName": "Knicka Somera",
        "CounterpartyContactNum": "09288377655",
        "CounterpartyContactEmail": "knicka@eastern.com",
        "CounterpartyContactLegal": null,
        "CounterpartyContactedB4": "Don't Know",
        "CounterpartyContactedYES": null,
        "CounterpartyChecks": "Don't know",
        "CounterpartyChecksYES": null,
        "ContractCommencement": "Annual",
        "ContractExpiry": "2021-07-23T16:00:00Z",
        "ContractDescription": "ISP for Tenant",
        "ContractGUSRole": "NA",
        "ContractCounterpartyOb": "Coordination",
        "ContractTotalValue": "188284673",
        "ContractCurrency": "PHP",
        "ContractAgreedPay": null,
        "ContractAttachment": "0",
        "ContractServiceCredit": "No",
        "ContractServiceCreditYES": null,
        "ContractGUSTerm": null,
        "ContractCounterpartTerm": null,
        "ContractAccessConfi": "No",
        "ContractAccessConfiYES": null,
        "ContractPartyPersonalAttach": "0",
        "ContractMemorandumAttach": "0",
        "ContractOtherParties": "No",
        "ContractOtherPartiesYES": null,
        "Comments": null,
        "CommentsStatements": null,
        "AuthorisationTick": null,
        "RequestingPerson": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "RequestingDAte": "2020-07-23T16:00:00Z",
        "LineManager": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 34,
          "LookupValue": "Manager Name",
          "Email": "Manager Email"
        },
        "LineManagerApproval": "Approved",
        "LegalAssignee": null,
        "Status": "Pending",
        "AutoTicket": {
          "__metadata": {
            "type": "SP.FieldUrlValue"
          },
          "Description": "Stage 1",
          "Url": "***_layouts/15/wrkstat.aspx?List=a0793150-5fb7-4d3d-a2ca-7e0a42f9acb5&WorkflowInstanceName=a18dd51b-1d8f-4d1e-b702-f218338f11f7"
        },
        "CounterpartGDPR": null,
        "LineMDateApprove": null,
        "LegalApproval": null,
        "LegalDateApprove": null,
        "Comment": null,
        "ID": 11,
        "Modified": "2020-07-29T05:51:24Z",
        "Author": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "Editor": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "OData__x005f_HasCopyDestinations": null,
        "OData__x005f_CopySource": null,
        "owshiddenversion": 7,
        "WorkflowVersion": 1,
        "OData__x005f_UIVersion": 1024,
        "OData__x005f_UIVersionString": "2.0",
        "Attachments": true,
        "OData__x005f_ModerationStatus": 0,
        "InstanceID": null,
        "Order": 1100,
        "GUID": "f22dfd1d-24f0-4c5f-8b22-6528c0e91455",
        "WorkflowInstanceID": null,
        "FileRef": "/site/Lists/Legal Request/11_.000",
        "FileDirRef": "/site/Lists/Legal Request",
        "Last_x005f_x0020_x005f_Modified": "2020-07-24T14:08:45Z",
        "Created_x005f_x0020_x005f_Date": "2020-07-24T14:08:45Z",
        "FSObjType": "0",
        "SortBehavior": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": "0"
        },
        "FileLeafRef": "11_.000",
        "UniqueId": "abc3d345-ee69-4850-8adf-352cd51a17a4",
        "SyncClientId": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": null
        },
        "ProgId": "",
        "ScopeId": "{41E3778F-1824-4A4D-8B81-5C39B65BAB3D}",
        "MetaInfo": "",
        "OData__x005f_Level": 1,
        "OData__x005f_IsCurrentVersion": false,
        "ItemChildCount": "0",
        "FolderChildCount": "0",
        "Restricted": "",
        "OriginatorId": "",
        "NoExecute": "0",
        "ContentVersion": "0",
        "OData__x005f_ComplianceFlags": "",
        "OData__x005f_ComplianceTag": "",
        "OData__x005f_ComplianceTagWrittenTime": "",
        "OData__x005f_ComplianceTagUserId": "",
        "AccessPolicy": "",
        "OData__x005f_VirusStatus": "",
        "OData__x005f_VirusVendorID": "",
        "OData__x005f_VirusInfo": "",
        "AppAuthor": null,
        "AppEditor": null,
        "SMTotalSize": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 7910,
          "LookupValue": ""
        },
        "SMLastModifiedDate": "2020-08-04T11:44:07Z",
        "SMTotalFileStreamSize": "0",
        "SMTotalFileCount": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 0,
          "LookupValue": ""
        },
        "OData__x005f_CommentFlags": "",
        "OData__x005f_CommentCount": ""
      },
      {
        "__metadata": {
          "id": "***_api/SP.ListItemVersion187213a9-3c1d-4f25-b789-3f7e48dfc901",
          "uri": "***_api/SP.ListItemVersion187213a9-3c1d-4f25-b789-3f7e48dfc901",
          "type": "SP.ListItemVersion"
        },
        "CreatedBy": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion187213a9-3c1d-4f25-b789-3f7e48dfc901/CreatedBy"
          }
        },
        "Fields": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion187213a9-3c1d-4f25-b789-3f7e48dfc901/Fields"
          }
        },
        "FileVersion": {
          "__deferred": {
            "uri": "***_api/SP.ListItemVersion187213a9-3c1d-4f25-b789-3f7e48dfc901/FileVersion"
          }
        },
        "Created": "2020-07-27T06:01:31",
        "IsCurrentVersion": false,
        "VersionId": 512,
        "VersionLabel": "1.0",
        "ContentTypeId": {
          "__metadata": {
            "type": "SP.ContentTypeId"
          },
          "StringValue": "0x0100EC80A015AF11544CBF624F41C03D4C42"
        },
        "Title": "ITC",
        "OData__x005f_ModerationComments": null,
        "File_x005f_x0020_x005f_Type": null,
        "ComplianceAssetId": null,
        "IncrementNumber": 11,
        "Requester": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "IssueNo": "Legal-0011",
        "DateRequested": "2020-07-23T16:00:00Z",
        "RequestType": "Contract Review",
        "Entity": null,
        "OtherEntity": null,
        "CounterpartyType": "Variation",
        "CounterpartyName": "Eastern Telecom",
        "CounterpartyContactName": "Knicka Somera",
        "CounterpartyContactNum": "09288377655",
        "CounterpartyContactEmail": "knicka@eastern.com",
        "CounterpartyContactLegal": null,
        "CounterpartyContactedB4": "Don't Know",
        "CounterpartyContactedYES": null,
        "CounterpartyChecks": "Don't know",
        "CounterpartyChecksYES": null,
        "ContractCommencement": "Annual",
        "ContractExpiry": "2021-07-23T16:00:00Z",
        "ContractDescription": "ISP for Tenant",
        "ContractGUSRole": "NA",
        "ContractCounterpartyOb": "Coordination",
        "ContractTotalValue": "188284673",
        "ContractCurrency": "PHP",
        "ContractAgreedPay": null,
        "ContractAttachment": "0",
        "ContractServiceCredit": "No",
        "ContractServiceCreditYES": null,
        "ContractGUSTerm": null,
        "ContractCounterpartTerm": null,
        "ContractAccessConfi": "No",
        "ContractAccessConfiYES": null,
        "ContractPartyPersonalAttach": "0",
        "ContractMemorandumAttach": "0",
        "ContractOtherParties": "No",
        "ContractOtherPartiesYES": null,
        "Comments": null,
        "CommentsStatements": null,
        "AuthorisationTick": null,
        "RequestingPerson": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "RequestingDAte": "2020-07-23T16:00:00Z",
        "LineManager": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 34,
          "LookupValue": "Manager Name",
          "Email": "Manager Email"
        },
        "LineManagerApproval": "Approved",
        "LegalAssignee": null,
        "Status": "Pending",
        "AutoTicket": {
          "__metadata": {
            "type": "SP.FieldUrlValue"
          },
          "Description": "Stage 1",
          "Url": "***_layouts/15/wrkstat.aspx?List=a0793150-5fb7-4d3d-a2ca-7e0a42f9acb5&WorkflowInstanceName=a18dd51b-1d8f-4d1e-b702-f218338f11f7"
        },
        "CounterpartGDPR": null,
        "LineMDateApprove": null,
        "LegalApproval": null,
        "LegalDateApprove": null,
        "Comment": null,
        "ID": 11,
        "Modified": "2020-07-27T06:01:31Z",
        "Author": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "Editor": {
          "__metadata": {
            "type": "SP.FieldUserValue"
          },
          "LookupId": 14,
          "LookupValue": "User Name",
          "Email": "User Email"
        },
        "OData__x005f_HasCopyDestinations": null,
        "OData__x005f_CopySource": null,
        "owshiddenversion": 6,
        "WorkflowVersion": 1,
        "OData__x005f_UIVersion": 512,
        "OData__x005f_UIVersionString": "1.0",
        "Attachments": true,
        "OData__x005f_ModerationStatus": 0,
        "InstanceID": null,
        "Order": 1100,
        "GUID": "f22dfd1d-24f0-4c5f-8b22-6528c0e91455",
        "WorkflowInstanceID": null,
        "FileRef": "/site/Lists/Legal Request/11_.000",
        "FileDirRef": "/site/Lists/Legal Request",
        "Last_x005f_x0020_x005f_Modified": "2020-07-24T14:08:45Z",
        "Created_x005f_x0020_x005f_Date": "2020-07-24T14:08:45Z",
        "FSObjType": "0",
        "SortBehavior": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": "0"
        },
        "FileLeafRef": "11_.000",
        "UniqueId": "abc3d345-ee69-4850-8adf-352cd51a17a4",
        "SyncClientId": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 11,
          "LookupValue": null
        },
        "ProgId": "",
        "ScopeId": "{41E3778F-1824-4A4D-8B81-5C39B65BAB3D}",
        "MetaInfo": "",
        "OData__x005f_Level": 1,
        "OData__x005f_IsCurrentVersion": false,
        "ItemChildCount": "0",
        "FolderChildCount": "0",
        "Restricted": "",
        "OriginatorId": "",
        "NoExecute": "0",
        "ContentVersion": "0",
        "OData__x005f_ComplianceFlags": "",
        "OData__x005f_ComplianceTag": "",
        "OData__x005f_ComplianceTagWrittenTime": "",
        "OData__x005f_ComplianceTagUserId": "",
        "AccessPolicy": "",
        "OData__x005f_VirusStatus": "",
        "OData__x005f_VirusVendorID": "",
        "OData__x005f_VirusInfo": "",
        "AppAuthor": null,
        "AppEditor": null,
        "SMTotalSize": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 7910,
          "LookupValue": ""
        },
        "SMLastModifiedDate": "2020-08-04T11:44:07Z",
        "SMTotalFileStreamSize": "0",
        "SMTotalFileCount": {
          "__metadata": {
            "type": "SP.FieldLookupValue"
          },
          "LookupId": 0,
          "LookupValue": ""
        },
        "OData__x005f_CommentFlags": "",
        "OData__x005f_CommentCount": ""
      }
    ]
  }
}

 

Appreciate your help on this. Thank you!

Highlighted
Super User II
Super User II

Re: Action 'Apply_to_each' failed

Hello @kristinamariz 

After the parse JSON action you could do something like this:

parseJson.png

1) For each "result" item: 

outputs('Parse_JSON')?['d']?['results']

2) Get the comments value:

items('apply_to_each')?['comments']

 

Hope it helps!

Ferran 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

Highlighted
Helper II
Helper II

Re: Action 'Apply_to_each' failed

Hi @fchopo, will try this and keep you posted. Thankie!

Highlighted
Helper II
Helper II

Re: Action 'Apply_to_each' failed

Hi @fchopo, I still encounter error for "Apply to each" action:

kristinamariz_0-1596632318263.png

 

kristinamariz_1-1596632351117.png

Kindly check. Thank you!

Highlighted
Helper II
Helper II

Re: Action 'Apply_to_each' failed

Hi @fchopo, I was able to generate the value for the "Apply to each" when I made a test result for the parse JSON action that you showed me. With that, I can now show the comments form the app!

 

Before adding comment, here's the existing list (thought I haven't filtered yet comments that are null):

kristinamariz_0-1597049314700.png

 

After submitting a comment:

kristinamariz_1-1597049378583.png

 

Appreciate your patience and thank you so much for the guidance! 😁

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (5,076)