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.
Solved! Go to Solution.
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"
]
}
}
}
}
}
}
Proud to be a Flownaut!
please @Pinoq try this
"heat_index_f": {
"type": ["number","null"]
},
change your d.results[1].Status Type for the example
Proud to be a Flownaut!
@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
Proud to be a Flownaut!
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"
]
}
}
}
}
}
}
Proud to be a Flownaut!
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?
User | Count |
---|---|
92 | |
44 | |
21 | |
18 | |
16 |
User | Count |
---|---|
137 | |
49 | |
42 | |
37 | |
29 |