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](https://powerusers.microsoft.com/t5/image/serverpage/image-id/131393i641E24D1931DDAC8/image-size/medium/is-moderation-mode/true?v=v2&px=400 "[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
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
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 LAplease @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
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 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
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
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
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
Helpful resources
Power Automate News & Announcements
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
