Power Platform Community Forum Thread Details

I am trying to convert data from a "Send an HTTP Request" to an Excel table. My requset come back with user data {"displayName":"First Last","mail":"FirstLast@mailbox.com","lastPasswordChangeDateTime":"2024-10-02T14:10:12Z"}. I see all the users in this data correctly. I found some examples on the web that say to use Parse JSON after request and then add a row to a table. I have the Table columns setup with "displayName", "mail", and "lastPasswordChangeDateTime. In the "add a row into a table" I match up the data from the Parse JSON output. When I run the Flow the Table has no data in it but everything runs. These are the parameters of the Add a row -

dateTimeFormat": "ISO 8601",

"item/displayname": null,

"item/mail": null,

"item/lastPasswordChangeDateTime": null

Categories:

Using flows

My main goal here is to understand how to parse the data. I did try an apply to all on the add a row to table and that did not work.

Body -
{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users(displayName,mail,lastPasswordChangeDateTime)",
"@odata.count": 1395,
"@odata.nextLink": "https://graph.microsoft.com/v1.0/users?$count=true&$top=999&$select=displayName%2cmail%2clastPasswordChangeDateTime&$filter=mail+ne+null+and+userType++eq+%27Member%27+and+assignedLicenses%2f%24count+ne+0&$skiptoken=m~AQAoO2I4NzAxN2JkOWE0MzQ3YzdhNDExMjkzZDY4ZGVhODU4OzswOzA7Ow",
"value": [
    {
      "displayName": "Coltin Savor",
      "mail": "csavor@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-13T12:54:15Z"
    },
    {
      "displayName": "Linda Ledbetter",
      "mail": "lledbetter@mailbox.com",
      "lastPasswordChangeDateTime": "2024-10-02T14:10:12Z"
    },
    {
      "displayName": "Susan Mallins",
      "mail": "smallins@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-19T13:40:00Z"
    },
    {
      "displayName": "Mabel Salazar",
      "mail": "msalazar@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-17T14:11:20Z"
    },
    {
      "displayName": "Hank Daly",
      "mail": "hdaly@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-19T13:20:38Z"
    },
    {
      "displayName": "Caity Seals",
      "mail": "cseals@mailbox.com",
      "lastPasswordChangeDateTime": "2024-08-23T02:00:53Z"
    },
    {
      "displayName": "Evita Alvarez-Santos",
      "mail": "ealvarez-santos@mailbox.com",
      "lastPasswordChangeDateTime": "2024-10-01T19:13:41Z"
    },
    {
      "displayName": "Sydney Smith",
      "mail": "sysmith@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-30T19:29:14Z"
    },
    {
      "displayName": "Jonathan Ross",
      "mail": "joross@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-16T19:41:57Z"
    },
    {
      "displayName": "Recruiter Zoom",
      "mail": "RecruiterZoom@mailbox.com",
      "lastPasswordChangeDateTime": "2021-04-28T16:06:58Z"
    },
    {
      "displayName": "Toni Adams",
      "mail": "anadams@mailbox.com",
      "lastPasswordChangeDateTime": "2024-08-25T09:57:38Z"
    },
    {
      "displayName": "Javier Lopez del Castillo Caymares",
      "mail": "jcaymares@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-04T12:41:44Z"
    },
    {
      "displayName": "Tiffiany Ashley",
      "mail": "tashley@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-04T01:21:05Z"
    },
    {
      "displayName": "Stephanie Kester",
      "mail": "skester@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-15T17:35:39Z"
    },
    {
      "displayName": "Auto Confirmations 2",
      "mail": "autoconfirmations2@mailbox.com",
      "lastPasswordChangeDateTime": "2023-05-31T17:31:59Z"
    },
    {
      "displayName": "Mel Marcus",
      "mail": "mmarcus@mailbox.com",
      "lastPasswordChangeDateTime": "2024-10-02T18:21:19Z"
    },
    {
      "displayName": "Joel Requena",
      "mail": "jrequena@mailbox.com",
      "lastPasswordChangeDateTime": "2024-10-04T15:42:17Z"
    },
    {
      "displayName": "Zoe Smith",
      "mail": "zsmith@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-06T15:55:05Z"
    },
    {
      "displayName": "Brittany Butler",
      "mail": "bbutler@mailbox.com",
      "lastPasswordChangeDateTime": "2024-08-26T13:07:45Z"
    },
    {
      "displayName": "Mary Johnson",
      "mail": "majohnson@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-26T12:02:36Z"
    },
    {
      "displayName": "Kathleen Wedral",
      "mail": "kwedral@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-04T14:45:18Z"
    },
    {
      "displayName": "Yarleny Cordero",
      "mail": "ycordero@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-09T02:04:39Z"
    },
    {
      "displayName": "Greg Campbell",
      "mail": "gcampbell@mailbox.com",
      "lastPasswordChangeDateTime": "2024-08-29T12:06:21Z"
    },
    {
      "displayName": "Sales Comm Team",
      "mail": "salescommteam@mailbox.com",
      "lastPasswordChangeDateTime": "2022-06-28T17:28:50Z"
    },
    {
      "displayName": "Michael Lee",
      "mail": "milee@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-10T21:15:52Z"
    },
    {
      "displayName": "Kaity Cruz Perez",
      "mail": "kcruzperez@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-19T02:19:24Z"
    },
    {
      "displayName": "Samarria Ladson",
      "mail": "sladson@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-03T14:22:11Z"
    },
    {
      "displayName": "Deniel Sanchez",
      "mail": "dsanchez@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-12T13:17:41Z"
    },
    {
      "displayName": "Dawn Kaes Warburton-Kaes",
      "mail": "dwarburtonkaes@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-09T18:47:29Z"
    },
    {
List goes on…….

{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users(displayName,mail,lastPasswordChangeDateTime)",
"@odata.count": 1395,
"@odata.nextLink": "https://graph.microsoft.com/v1.0/users?$count=true&$top=999&$select=displayName%2cmail%2clastPasswordChangeDateTime&$filter=mail+ne+null+and+userType++eq+%27Member%27+and+assignedLicenses%2f%24count+ne+0&$skiptoken=m~AQAoO2I4NzAxN2JkOWE0MzQ3YzdhNDExMjkzZDY4ZGVhODU4OzswOzA7Ow",
"value": [
    {
      "displayName": "Coltin Savor",
      "mail": "csavor@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-13T12:54:15Z"
    },
    {
      "displayName": "Linda Ledbetter",
      "mail": "lledbetter@mailbox.com",
      "lastPasswordChangeDateTime": "2024-10-02T14:10:12Z"
    },
    {
      "displayName": "Susan Mallins",
      "mail": "smallins@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-19T13:40:00Z"
    },
    {
      "displayName": "Mabel Salazar",
      "mail": "msalazar@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-17T14:11:20Z"
    },
    {
      "displayName": "Hank Daly",
      "mail": "hdaly@mailbox.com",
      "lastPasswordChangeDateTime": "2024-09-19T13:20:38Z"
    },
    {
      "displayName": "Caity Seals",
      "mail": "cseals@mailbox.com",
      "lastPasswordChangeDateTime": "2024-08-23T02:00:53Z"
    },
    {
      "displayName": "Evita Alvarez-Santos",
      "mail": "ealvarez-santos@mailbox.com",
      "lastPasswordChangeDateTime": "2024-10-01T19:13:41Z"
    },
    {
List goes on…….

{
"@odata.context": "https://excelonline-eus2.azconn-eus2-003.p.azurewebsites.net/$metadata#drives('b%21yk6dtNzBp0GsHDNYVEra589ILD4hd8xNsSjO6O0cZXJGPP1HpxQQRIb3VOE3L3Bl')/Files('014K223UCYV5VSRHVDUJH3D7GDI2OKW5NX')/Tables('%7B95439799-66BB-413D-A998-FB68B149BAE1%7D')/items/$entity",
"@odata.etag": "",
"ItemInternalId": "2ad349ea-d1cf-4bf5-b932-250dfe8cb873"
}