cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pinoq
Helper IV
Helper IV

Get the information in specific column of two version

I have to create a portal to store the information for a new join staff. Now I want to create a work flow that only when some column of my list modified, get the column data of the list before and after modified by. And send email to HR to confirm. I try to follow this method https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Check-for-a-Change-in-a-SharePoint... to get the data of the last two version and try to put it to a variable. But I failed.

 Below is the error message of my Parse JSON. The type of my status column is single line of text and the column is update by another flow with send an option email.[Equipment Portal]Version compare.PNG
 
[
  {
    "message""Invalid type. Expected String but got Null.",
    "lineNumber"0,
    "linePosition"0,
    "path""d.results[1].Status",
    "schemaId""#/properties/d/properties/results/items/properties/Status",
    "errorType""type",
    "childErrors": []
  }
]
 
1 ACCEPTED SOLUTION

Accepted Solutions

@Pinoq 

 

please copy this

 

{
    "type": "object",
    "properties": {
        "d": {
            "type": "object",
            "properties": {
                "results": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "__metadata": {
                                "type": "object",
                                "properties": {
                                    "id": {
                                        "type": "string"
                                    },
                                    "uri": {
                                        "type": "string"
                                    },
                                    "type": {
                                        "type": "string"
                                    }
                                }
                            },
                            "CreatedBy": {
                                "type": "object",
                                "properties": {
                                    "__deferred": {
                                        "type": "object",
                                        "properties": {
                                            "uri": {
                                                "type": "string"
                                            }
                                        }
                                    }
                                }
                            },
                            "Fields": {
                                "type": "object",
                                "properties": {
                                    "__deferred": {
                                        "type": "object",
                                        "properties": {
                                            "uri": {
                                                "type": "string"
                                            }
                                        }
                                    }
                                }
                            },
                            "FileVersion": {
                                "type": "object",
                                "properties": {
                                    "__deferred": {
                                        "type": "object",
                                        "properties": {
                                            "uri": {
                                                "type": "string"
                                            }
                                        }
                                    }
                                }
                            },
                            "Created": {
                                "type": "string"
                            },
                            "IsCurrentVersion": {
                                "type": "boolean"
                            },
                            "VersionId": {
                                "type": "integer"
                            },
                            "VersionLabel": {
                                "type": "string"
                            },
                            "ContentTypeId": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "StringValue": {
                                        "type": "string"
                                    }
                                }
                            },
                            "Title": {},
                            "OData__x005f_ModerationComments": {},
                            "File_x005f_x0020_x005f_Type": {},
                            "ComplianceAssetId": {},
                            "Person": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    },
                                    "Email": {
                                        "type": "string"
                                    }
                                }
                            },
                            "Monitor": {
                                "type": "string"
                            },
                            "Laptop": {
                                "type": "string"
                            },
                            "PC": {
                                "type": "string"
                            },
                            "Special_x005f_x0020_x005f_Cable": {},
                            "Keyboard_x005f_x0020_x005f_or_x005f_x0020_x005f_Mouse": {},
                            "Other": {},
                            "OData__x005f_ModerationStatus": {
                                "type": "integer"
                            },
                            "Region": {},
                            "Status": {
                                "type": ["number","null"]
                            },
                            "Location": {
                                "type": "string"
                            },
                            "ID": {
                                "type": "integer"
                            },
                            "Modified": {
                                "type": "string"
                            },
                            "Author": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    },
                                    "Email": {
                                        "type": "string"
                                    }
                                }
                            },
                            "Editor": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    },
                                    "Email": {
                                        "type": "string"
                                    }
                                }
                            },
                            "OData__x005f_HasCopyDestinations": {},
                            "OData__x005f_CopySource": {},
                            "owshiddenversion": {
                                "type": "integer"
                            },
                            "WorkflowVersion": {
                                "type": "integer"
                            },
                            "OData__x005f_UIVersion": {
                                "type": "integer"
                            },
                            "OData__x005f_UIVersionString": {
                                "type": "string"
                            },
                            "Attachments": {
                                "type": "boolean"
                            },
                            "InstanceID": {},
                            "Order": {
                                "type": "integer"
                            },
                            "GUID": {
                                "type": "string"
                            },
                            "WorkflowInstanceID": {},
                            "FileRef": {
                                "type": "string"
                            },
                            "FileDirRef": {
                                "type": "string"
                            },
                            "Last_x005f_x0020_x005f_Modified": {
                                "type": "string"
                            },
                            "Created_x005f_x0020_x005f_Date": {
                                "type": "string"
                            },
                            "FSObjType": {
                                "type": "string"
                            },
                            "SortBehavior": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    }
                                }
                            },
                            "FileLeafRef": {
                                "type": "string"
                            },
                            "UniqueId": {
                                "type": "string"
                            },
                            "SyncClientId": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {}
                                }
                            },
                            "ProgId": {
                                "type": "string"
                            },
                            "ScopeId": {
                                "type": "string"
                            },
                            "MetaInfo": {
                                "type": "string"
                            },
                            "OData__x005f_Level": {
                                "type": "integer"
                            },
                            "OData__x005f_IsCurrentVersion": {
                                "type": "boolean"
                            },
                            "ItemChildCount": {
                                "type": "string"
                            },
                            "FolderChildCount": {
                                "type": "string"
                            },
                            "Restricted": {
                                "type": "string"
                            },
                            "OriginatorId": {
                                "type": "string"
                            },
                            "NoExecute": {
                                "type": "string"
                            },
                            "ContentVersion": {
                                "type": "string"
                            },
                            "OData__x005f_ComplianceFlags": {
                                "type": "string"
                            },
                            "OData__x005f_ComplianceTag": {
                                "type": "string"
                            },
                            "OData__x005f_ComplianceTagWrittenTime": {
                                "type": "string"
                            },
                            "OData__x005f_ComplianceTagUserId": {
                                "type": "string"
                            },
                            "AccessPolicy": {
                                "type": "string"
                            },
                            "OData__x005f_VirusStatus": {
                                "type": "string"
                            },
                            "OData__x005f_VirusVendorID": {
                                "type": "string"
                            },
                            "OData__x005f_VirusInfo": {
                                "type": "string"
                            },
                            "AppAuthor": {},
                            "AppEditor": {},
                            "SMTotalSize": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    }
                                }
                            },
                            "SMLastModifiedDate": {
                                "type": "string"
                            },
                            "SMTotalFileStreamSize": {
                                "type": "string"
                            },
                            "SMTotalFileCount": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    }
                                }
                            }
                        },
                        "required": [
                            "__metadata",
                            "CreatedBy",
                            "Fields",
                            "FileVersion",
                            "Created",
                            "IsCurrentVersion",
                            "VersionId",
                            "VersionLabel",
                            "ContentTypeId",
                            "Title",
                            "OData__x005f_ModerationComments",
                            "File_x005f_x0020_x005f_Type",
                            "ComplianceAssetId",
                            "Person",
                            "Monitor",
                            "Laptop",
                            "PC",
                            "Special_x005f_x0020_x005f_Cable",
                            "Keyboard_x005f_x0020_x005f_or_x005f_x0020_x005f_Mouse",
                            "Other",
                            "OData__x005f_ModerationStatus",
                            "Region",
                            "Status",
                            "Location",
                            "ID",
                            "Modified",
                            "Author",
                            "Editor",
                            "OData__x005f_HasCopyDestinations",
                            "OData__x005f_CopySource",
                            "owshiddenversion",
                            "WorkflowVersion",
                            "OData__x005f_UIVersion",
                            "OData__x005f_UIVersionString",
                            "Attachments",
                            "InstanceID",
                            "Order",
                            "GUID",
                            "WorkflowInstanceID",
                            "FileRef",
                            "FileDirRef",
                            "Last_x005f_x0020_x005f_Modified",
                            "Created_x005f_x0020_x005f_Date",
                            "FSObjType",
                            "SortBehavior",
                            "FileLeafRef",
                            "UniqueId",
                            "SyncClientId",
                            "ProgId",
                            "ScopeId",
                            "MetaInfo",
                            "OData__x005f_Level",
                            "OData__x005f_IsCurrentVersion",
                            "ItemChildCount",
                            "FolderChildCount",
                            "Restricted",
                            "OriginatorId",
                            "NoExecute",
                            "ContentVersion",
                            "OData__x005f_ComplianceFlags",
                            "OData__x005f_ComplianceTag",
                            "OData__x005f_ComplianceTagWrittenTime",
                            "OData__x005f_ComplianceTagUserId",
                            "AccessPolicy",
                            "OData__x005f_VirusStatus",
                            "OData__x005f_VirusVendorID",
                            "OData__x005f_VirusInfo",
                            "AppAuthor",
                            "AppEditor",
                            "SMTotalSize",
                            "SMLastModifiedDate",
                            "SMTotalFileStreamSize",
                            "SMTotalFileCount"
                        ]
                    }
                }
            }
        }
    }
}


Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

5 REPLIES 5
ChristianAbata
Super User
Super User

please @Pinoq  try this

 

"heat_index_f": {
"type": ["number","null"]
},

 

 change your d.results[1].Status Type for the example



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Where should I change it?

@Pinoq  in your PArse json squema, if you copy and paste here your squema I can can change it your you to see the dirence



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@Pinoq 

 

please copy this

 

{
    "type": "object",
    "properties": {
        "d": {
            "type": "object",
            "properties": {
                "results": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "__metadata": {
                                "type": "object",
                                "properties": {
                                    "id": {
                                        "type": "string"
                                    },
                                    "uri": {
                                        "type": "string"
                                    },
                                    "type": {
                                        "type": "string"
                                    }
                                }
                            },
                            "CreatedBy": {
                                "type": "object",
                                "properties": {
                                    "__deferred": {
                                        "type": "object",
                                        "properties": {
                                            "uri": {
                                                "type": "string"
                                            }
                                        }
                                    }
                                }
                            },
                            "Fields": {
                                "type": "object",
                                "properties": {
                                    "__deferred": {
                                        "type": "object",
                                        "properties": {
                                            "uri": {
                                                "type": "string"
                                            }
                                        }
                                    }
                                }
                            },
                            "FileVersion": {
                                "type": "object",
                                "properties": {
                                    "__deferred": {
                                        "type": "object",
                                        "properties": {
                                            "uri": {
                                                "type": "string"
                                            }
                                        }
                                    }
                                }
                            },
                            "Created": {
                                "type": "string"
                            },
                            "IsCurrentVersion": {
                                "type": "boolean"
                            },
                            "VersionId": {
                                "type": "integer"
                            },
                            "VersionLabel": {
                                "type": "string"
                            },
                            "ContentTypeId": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "StringValue": {
                                        "type": "string"
                                    }
                                }
                            },
                            "Title": {},
                            "OData__x005f_ModerationComments": {},
                            "File_x005f_x0020_x005f_Type": {},
                            "ComplianceAssetId": {},
                            "Person": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    },
                                    "Email": {
                                        "type": "string"
                                    }
                                }
                            },
                            "Monitor": {
                                "type": "string"
                            },
                            "Laptop": {
                                "type": "string"
                            },
                            "PC": {
                                "type": "string"
                            },
                            "Special_x005f_x0020_x005f_Cable": {},
                            "Keyboard_x005f_x0020_x005f_or_x005f_x0020_x005f_Mouse": {},
                            "Other": {},
                            "OData__x005f_ModerationStatus": {
                                "type": "integer"
                            },
                            "Region": {},
                            "Status": {
                                "type": ["number","null"]
                            },
                            "Location": {
                                "type": "string"
                            },
                            "ID": {
                                "type": "integer"
                            },
                            "Modified": {
                                "type": "string"
                            },
                            "Author": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    },
                                    "Email": {
                                        "type": "string"
                                    }
                                }
                            },
                            "Editor": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    },
                                    "Email": {
                                        "type": "string"
                                    }
                                }
                            },
                            "OData__x005f_HasCopyDestinations": {},
                            "OData__x005f_CopySource": {},
                            "owshiddenversion": {
                                "type": "integer"
                            },
                            "WorkflowVersion": {
                                "type": "integer"
                            },
                            "OData__x005f_UIVersion": {
                                "type": "integer"
                            },
                            "OData__x005f_UIVersionString": {
                                "type": "string"
                            },
                            "Attachments": {
                                "type": "boolean"
                            },
                            "InstanceID": {},
                            "Order": {
                                "type": "integer"
                            },
                            "GUID": {
                                "type": "string"
                            },
                            "WorkflowInstanceID": {},
                            "FileRef": {
                                "type": "string"
                            },
                            "FileDirRef": {
                                "type": "string"
                            },
                            "Last_x005f_x0020_x005f_Modified": {
                                "type": "string"
                            },
                            "Created_x005f_x0020_x005f_Date": {
                                "type": "string"
                            },
                            "FSObjType": {
                                "type": "string"
                            },
                            "SortBehavior": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    }
                                }
                            },
                            "FileLeafRef": {
                                "type": "string"
                            },
                            "UniqueId": {
                                "type": "string"
                            },
                            "SyncClientId": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {}
                                }
                            },
                            "ProgId": {
                                "type": "string"
                            },
                            "ScopeId": {
                                "type": "string"
                            },
                            "MetaInfo": {
                                "type": "string"
                            },
                            "OData__x005f_Level": {
                                "type": "integer"
                            },
                            "OData__x005f_IsCurrentVersion": {
                                "type": "boolean"
                            },
                            "ItemChildCount": {
                                "type": "string"
                            },
                            "FolderChildCount": {
                                "type": "string"
                            },
                            "Restricted": {
                                "type": "string"
                            },
                            "OriginatorId": {
                                "type": "string"
                            },
                            "NoExecute": {
                                "type": "string"
                            },
                            "ContentVersion": {
                                "type": "string"
                            },
                            "OData__x005f_ComplianceFlags": {
                                "type": "string"
                            },
                            "OData__x005f_ComplianceTag": {
                                "type": "string"
                            },
                            "OData__x005f_ComplianceTagWrittenTime": {
                                "type": "string"
                            },
                            "OData__x005f_ComplianceTagUserId": {
                                "type": "string"
                            },
                            "AccessPolicy": {
                                "type": "string"
                            },
                            "OData__x005f_VirusStatus": {
                                "type": "string"
                            },
                            "OData__x005f_VirusVendorID": {
                                "type": "string"
                            },
                            "OData__x005f_VirusInfo": {
                                "type": "string"
                            },
                            "AppAuthor": {},
                            "AppEditor": {},
                            "SMTotalSize": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    }
                                }
                            },
                            "SMLastModifiedDate": {
                                "type": "string"
                            },
                            "SMTotalFileStreamSize": {
                                "type": "string"
                            },
                            "SMTotalFileCount": {
                                "type": "object",
                                "properties": {
                                    "__metadata": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            }
                                        }
                                    },
                                    "LookupId": {
                                        "type": "integer"
                                    },
                                    "LookupValue": {
                                        "type": "string"
                                    }
                                }
                            }
                        },
                        "required": [
                            "__metadata",
                            "CreatedBy",
                            "Fields",
                            "FileVersion",
                            "Created",
                            "IsCurrentVersion",
                            "VersionId",
                            "VersionLabel",
                            "ContentTypeId",
                            "Title",
                            "OData__x005f_ModerationComments",
                            "File_x005f_x0020_x005f_Type",
                            "ComplianceAssetId",
                            "Person",
                            "Monitor",
                            "Laptop",
                            "PC",
                            "Special_x005f_x0020_x005f_Cable",
                            "Keyboard_x005f_x0020_x005f_or_x005f_x0020_x005f_Mouse",
                            "Other",
                            "OData__x005f_ModerationStatus",
                            "Region",
                            "Status",
                            "Location",
                            "ID",
                            "Modified",
                            "Author",
                            "Editor",
                            "OData__x005f_HasCopyDestinations",
                            "OData__x005f_CopySource",
                            "owshiddenversion",
                            "WorkflowVersion",
                            "OData__x005f_UIVersion",
                            "OData__x005f_UIVersionString",
                            "Attachments",
                            "InstanceID",
                            "Order",
                            "GUID",
                            "WorkflowInstanceID",
                            "FileRef",
                            "FileDirRef",
                            "Last_x005f_x0020_x005f_Modified",
                            "Created_x005f_x0020_x005f_Date",
                            "FSObjType",
                            "SortBehavior",
                            "FileLeafRef",
                            "UniqueId",
                            "SyncClientId",
                            "ProgId",
                            "ScopeId",
                            "MetaInfo",
                            "OData__x005f_Level",
                            "OData__x005f_IsCurrentVersion",
                            "ItemChildCount",
                            "FolderChildCount",
                            "Restricted",
                            "OriginatorId",
                            "NoExecute",
                            "ContentVersion",
                            "OData__x005f_ComplianceFlags",
                            "OData__x005f_ComplianceTag",
                            "OData__x005f_ComplianceTagWrittenTime",
                            "OData__x005f_ComplianceTagUserId",
                            "AccessPolicy",
                            "OData__x005f_VirusStatus",
                            "OData__x005f_VirusVendorID",
                            "OData__x005f_VirusInfo",
                            "AppAuthor",
                            "AppEditor",
                            "SMTotalSize",
                            "SMLastModifiedDate",
                            "SMTotalFileStreamSize",
                            "SMTotalFileCount"
                        ]
                    }
                }
            }
        }
    }
}


Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Thanks a lot!!!!It works now, due to I want to know more and can fix it myself next time, can you explain why I need to change it this way?

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,094)