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

Response to PowerApps from Send HTTP request to SharePoint

Hi All,

I am trying to build a Flow which will send an HTTP request to SharePoint and get a list item version. I have been able to do that successfully and i am parsing the output as json. Now i am stuck as to how the data can be sent to PowerApps. 
I want to show in PowerApps what has been changed for that particular SharePoint Item be it any column.

How can i do it? Attaching the Flow and Response from JSON.
Please help how can i achieve this?

 

{
    "body": {
        "d": {
            "results": [
                {
                    "__metadata": {
                        "id": "https://test.sharepoint.com/sites/test/_api/SP.ListItemVersionf7c2d72f-6d54-45c4-8e62-7c59bda1f8f6",
                        "uri": "https://test.sharepoint.com/sites/test/_api/SP.ListItemVersionf7c2d72f-6d54-45c4-8e62-7c59bda1f8f6",
                        "type": "SP.ListItemVersion"
                    },
                    "CreatedBy": {
                        "__deferred": {
                            "uri": "https://test.sharepoint.com/sites/test/_api/SP.ListItemVersionf7c2d72f-6d54-45c4-8e62-7c59bda1f8f6/CreatedBy"
                        }
                    },
                    "Fields": {
                        "__deferred": {
                            "uri": "https://test.sharepoint.com/sites/test/_api/SP.ListItemVersionf7c2d72f-6d54-45c4-8e62-7c59bda1f8f6/Fields"
                        }
                    },
                    "FileVersion": {
                        "__deferred": {
                            "uri": "https://test.sharepoint.com/sites/test/_api/SP.ListItemVersionf7c2d72f-6d54-45c4-8e62-7c59bda1f8f6/FileVersion"
                        }
                    },
                    "Created": "2021-11-20T08:07:50",
                    "IsCurrentVersion": true,
                    "VersionId": 1024,
                    "VersionLabel": "2.0",
                    "ID": 51,
                    "ContentTypeId": {
                        "__metadata": {
                            "type": "SP.ContentTypeId"
                        },
                        "StringValue": "0x0100CD7796FA0DF0924B8AE80879369C27B200C178E7F8A3E17D4B91135341812C8E06"
                    },
                    "Title": "Test Carrier2",
                    "Modified": "2021-11-20T08:07:50Z",
                    "Author": {
                        "__metadata": {
                            "type": "SP.FieldUserValue"
                        },
                        "LookupId": 25,
                        "LookupValue": "Test User",
                        "Email": "testuser@gmail"
                    },
                    "Editor": {
                        "__metadata": {
                            "type": "SP.FieldUserValue"
                        },
                        "LookupId": 25,
                        "LookupValue": "Test User",
                        "Email": "testuser@gmail"
                    },
                    "OData__x005f_HasCopyDestinations": null,
                    "OData__x005f_CopySource": null,
                    "owshiddenversion": 2,
                    "WorkflowVersion": 1,
                    "OData__x005f_UIVersion": 1024,
                    "OData__x005f_UIVersionString": "2.0",
                    "Attachments": false,
                    "OData__x005f_ModerationStatus": 0,
                    "OData__x005f_ModerationComments": null,
                    "InstanceID": null,
                    "Order": 5100,
                    "GUID": "ca662130-d835-4710-91ca-3472c99aaf25",
                    "WorkflowInstanceID": null,
                    "FileRef": "/sites/test/Lists/test/51_.000",
                    "FileDirRef": "/sites/test/Lists/test",
                    "Last_x005f_x0020_x005f_Modified": "2021-11-10T08:24:25Z",
                    "Created_x005f_x0020_x005f_Date": "2021-11-10T08:24:25Z",
                    "FSObjType": "0",
                    "SortBehavior": {
                        "__metadata": {
                            "type": "SP.FieldLookupValue"
                        },
                        "LookupId": 51,
                        "LookupValue": "0"
                    },
                    "UniqueId": "b820d95d-1001-4fb7-918c-af620393f183",
                    "SyncClientId": {
                        "__metadata": {
                            "type": "SP.FieldLookupValue"
                        },
                        "LookupId": 51,
                        "LookupValue": null
                    },
                    "ProgId": "",
                    "ScopeId": "{4E94C8A2-3933-4E2C-B16F-B8DD1E566261}",
                    "File_x005f_x0020_x005f_Type": null,
                    "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": 410,
                        "LookupValue": ""
                    },
                    "SMLastModifiedDate": "2021-11-20T08:07:50Z",
                    "SMTotalFileStreamSize": "0",
                    "SMTotalFileCount": {
                        "__metadata": {
                            "type": "SP.FieldLookupValue"
                        },
                        "LookupId": 0,
                        "LookupValue": ""
                    },
                    "ComplianceAssetId": null,
                    "WeekStartDate": "2021-11-07T18:30:00Z",
                    "WeekEndDate": "2021-11-16T18:30:00Z",
                    "Supplier": "Supplier 1",
                    "PartName": "Part A",
                    "ETADateandTime": "2021-11-10T07:30:00Z",
                    "Dock": "Dock1",
                    "ShipmentReceivedDate_x005f_x002f_x005f_Time": null,
                    "ShipmentReviseDate_x005f_x002f_x005f_Time": null,
                    "Date": "2021-11-07T18:30:00Z",
                    "ShipmentTime": "13:00",
                    "FileLeafRef": "51_.000",
                    "OData__x005f_CommentFlags": "",
                    "OData__x005f_CommentCount": ""
                },
                {
                    "__metadata": {
                        "id": "https://test.sharepoint.com/sites/test/_api/SP.ListItemVersionf7c2d72f-6d54-45c4-8e62-7c59bda1f8f6",
                        "uri": "https://test.sharepoint.com/sites/test/_api/SP.ListItemVersionf7c2d72f-6d54-45c4-8e62-7c59bda1f8f6",
                        "type": "SP.ListItemVersion"
                    },
                    "CreatedBy": {
                        "__deferred": {
                            "uri": "https://test.sharepoint.com/sites/test/_api/SP.ListItemVersionf7c2d72f-6d54-45c4-8e62-7c59bda1f8f6/CreatedBy"
                        }
                    },
                    "Fields": {
                        "__deferred": {
                            "uri": "https://test.sharepoint.com/sites/test/_api/SP.ListItemVersionf7c2d72f-6d54-45c4-8e62-7c59bda1f8f6/Fields"
                        }
                    },
                    "FileVersion": {
                        "__deferred": {
                            "uri": "https://test.sharepoint.com/sites/test/_api/SP.ListItemVersionf7c2d72f-6d54-45c4-8e62-7c59bda1f8f6/FileVersion"
                        }
                    },
                    "Created": "2021-11-10T08:24:25",
                    "IsCurrentVersion": false,
                    "VersionId": 512,
                    "VersionLabel": "1.0",
                    "ID": 51,
                    "ContentTypeId": {
                        "__metadata": {
                            "type": "SP.ContentTypeId"
                        },
                        "StringValue": "0x0100CD7796FA0DF0924B8AE80879369C27B200C178E7F8A3E17D4B91135341812C8E06"
                    },
                    "Title": "Test Carrier",
                    "Modified": "2021-11-10T08:24:25Z",
                    "Author": {
                        "__metadata": {
                            "type": "SP.FieldUserValue"
                        },
                        "LookupId": 25,
                        "LookupValue": "Test user",
                        "Email": "testuser@gmail.com"
                    },
                    "Editor": {
                        "__metadata": {
                            "type": "SP.FieldUserValue"
                        },
                        "LookupId": 25,
                        "LookupValue": "Test user",
                        "Email": "testuser@gmail.com"
                    },
                    "OData__x005f_HasCopyDestinations": null,
                    "OData__x005f_CopySource": null,
                    "owshiddenversion": 1,
                    "WorkflowVersion": 1,
                    "OData__x005f_UIVersion": 512,
                    "OData__x005f_UIVersionString": "1.0",
                    "Attachments": false,
                    "OData__x005f_ModerationStatus": 0,
                    "OData__x005f_ModerationComments": null,
                    "InstanceID": null,
                    "Order": 5100,
                    "GUID": "ca662130-d835-4710-91ca-3472c99aaf25",
                    "WorkflowInstanceID": null,
                    "FileRef": "/sites/test/Lists/test/51_.000",
                    "FileDirRef": "/sites/test/Lists/test",
                    "Last_x005f_x0020_x005f_Modified": "2021-11-10T08:24:25Z",
                    "Created_x005f_x0020_x005f_Date": "2021-11-10T08:24:25Z",
                    "FSObjType": "0",
                    "SortBehavior": {
                        "__metadata": {
                            "type": "SP.FieldLookupValue"
                        },
                        "LookupId": 51,
                        "LookupValue": "0"
                    },
                    "UniqueId": "b820d95d-1001-4fb7-918c-af620393f183",
                    "SyncClientId": {
                        "__metadata": {
                            "type": "SP.FieldLookupValue"
                        },
                        "LookupId": 51,
                        "LookupValue": null
                    },
                    "ProgId": "",
                    "ScopeId": "{4E94C8A2-3933-4E2C-B16F-B8DD1E566261}",
                    "File_x005f_x0020_x005f_Type": null,
                    "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": 410,
                        "LookupValue": ""
                    },
                    "SMLastModifiedDate": "2021-11-20T08:07:50Z",
                    "SMTotalFileStreamSize": "0",
                    "SMTotalFileCount": {
                        "__metadata": {
                            "type": "SP.FieldLookupValue"
                        },
                        "LookupId": 0,
                        "LookupValue": ""
                    },
                    "ComplianceAssetId": null,
                    "WeekStartDate": "2021-11-07T18:30:00Z",
                    "WeekEndDate": "2021-11-16T18:30:00Z",
                    "Supplier": "Supplier 1",
                    "PartName": "Part A",
                    "ETADateandTime": "2021-11-10T07:30:00Z",
                    "Dock": "Dock1",
                    "ShipmentReceivedDate_x005f_x002f_x005f_Time": null,
                    "ShipmentReviseDate_x005f_x002f_x005f_Time": null,
                    "Date": "2021-11-07T18:30:00Z",
                    "ShipmentTime": "13:00",
                    "FileLeafRef": "51_.000",
                    "OData__x005f_CommentFlags": "",
                    "OData__x005f_CommentCount": ""
                }
            ]
        }
    }
}

 

image.png

0 REPLIES 0

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,408)