Power Apps ParseJSON Function: Get Collection From A Flow

Hi Matt,
As always great post:)
Just wanted to add two cents that ForAll is quite slow 🙁 with AddColumns function you can process data much quicker:)
Manage to describe the method but here I will end up the self promotion:p

Ps. It is awesome to see how consistent your are with blogging! Keep it up 🙂

Hello Matthew! The info you’ve provided gives me hope that what I am try to accomplish is possible :). With that said here is the date recieved from flow:

{
  "9780980200447": {
    "bib_key": "9780980200447",
    "info_url": "https://openlibrary.org/books/OL22853304M/Slow_reading",
    "preview": "borrow",
    "preview_url": "https://archive.org/details/slowreading00mied",
    "thumbnail_url": "https://covers.openlibrary.org/b/id/5546156-S.jpg",
    "details": {
      "number_of_pages": 92,
      "table_of_contents": [
        {
          "level": 0,
          "title": "The personal nature of slow reading",
          "type": {
            "key": "/type/toc_item"
          }
        },
        {
          "level": 0,
          "title": "Slow reading in an information ecology",
          "type": {
            "key": "/type/toc_item"
          }
        },
        {
          "level": 0,
          "title": "The slow movement and slow reading",
          "type": {
            "key": "/type/toc_item"
          }
        },
        {
          "level": 0,
          "title": "The psychology of slow reading",
          "type": {
            "key": "/type/toc_item"
          }
        },
        {
          "level": 0,
          "title": "The practice of slow reading.",
          "type": {
            "key": "/type/toc_item"
          }
        }
      ],
      "contributors": [
        {
          "role": "Cover Photographs",
          "name": "C. Ekholm"
        }
      ],
      "isbn_10": [
        "1936117363"
      ],
      "covers": [
        5546156
      ],
      "lc_classifications": [
        "Z1003 .M58 2009"
      ],
      "ocaid": "slowreading00mied",
      "weight": "1 grams",
      "source_records": [
        "marc:marc_loc_updates/v37.i01.records.utf8:4714764:907",
        "marc:marc_loc_updates/v37.i24.records.utf8:7913973:914",
        "marc:marc_loc_updates/v37.i30.records.utf8:11406606:914",
        "ia:slowreading00mied",
        "marc:marc_openlibraries_sanfranciscopubliclibrary/sfpl_chq_2018_12_24_run04.mrc:135742902:2094",
        "marc:marc_loc_2016/BooksAll.2016.part35.utf8:160727336:914",
        "promise:bwb_daily_pallets_2022-09-12"
      ],
      "title": "Slow reading",
      "languages": [
        {
          "key": "/languages/eng"
        }
      ],
      "subjects": [
        "Books and reading",
        "Reading"
      ],
      "publish_country": "mnu",
      "by_statement": "by John Miedema.",
      "oclc_numbers": [
        "297222669"
      ],
      "type": {
        "key": "/type/edition"
      },
      "physical_dimensions": "7.81 x 5.06 x 1 inches",
      "publishers": [
        "Litwin Books"
      ],
      "description": "\"A study of voluntary slow reading from diverse angles\"--Provided by publisher.",
      "physical_format": "Paperback",
      "key": "/books/OL22853304M",
      "authors": [
        {
          "key": "/authors/OL6548935A",
          "name": "John Miedema"
        }
      ],
      "publish_places": [
        "Duluth, Minn"
      ],
      "pagination": "80p.",
      "classifications": {},
      "lccn": [
        "2008054742"
      ],
      "notes": "Includes bibliographical references and index.",
      "identifiers": {
        "amazon": [
          "098020044X"
        ],
        "google": [
          "4LQU1YwhY6kC"
        ],
        "librarything": [
          "8071257"
        ],
        "goodreads": [
          "6383507"
        ]
      },
      "isbn_13": [
        "9780980200447",
        "9781936117369"
      ],
      "dewey_decimal_class": [
        "028/.9"
      ],
      "local_id": [
        "urn:sfpl:31223095026424",
        "urn:bwbsku:O8-CNK-818"
      ],
      "publish_date": "March 2009",
      "works": [
        {
          "key": "/works/OL13694821W"
        }
      ],
      "latest_revision": 24,
      "revision": 24,
      "created": {
        "type": "/type/datetime",
        "value": "2009-01-07T22:16:11.381678"
      },
      "last_modified": {
        "type": "/type/datetime",
        "value": "2022-12-04T10:37:36.772707"
      }
    }
  }
}

The first number is a string passed as a variable from power apps to flow.

So my questions is: Why do you suppose the Collection is reading the keys but not returning the values?

Here is my simple code (in power apps):

ClearCollect(
    openLIBSearchResults,
    openLibraryResponse.Run(isbnInput.Text)
);

Thank you!

-Anthony

Great job Matthew ! i tried this exemple and it works fine. i have a question please ? if we have a nested array in the Json :

[
{
“companyname”: “MD”,
“companyID”: “327733184”,
“nombre_employee”: 51,

“managers”: [
“firstname”: “matthiew”,
“lastname”: “Devaney”
]
}
]

How can we access to manager list by compagny in this case in power apps ?

Best regards

I was facing a simular issue with a response from a child flow and didn´t want to use a premium connector. Thanks a lot.

Thank you SO much for this guide! Your scenario is almost identical to what I was trying to accomplish.

I was about to pull out my hair trying to figure this out. And I couldn’t find any other guides online that covered this scenario.

I need to learn to head straight to your website whenever I’m faced w/ a PowerApps issue.