web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parse Json and return ...
Power Automate
Unanswered

Parse Json and return outputs to powerapps

(0) ShareShare
ReportReport
Posted on by 4

I am completely stuck on the below flow, and can not for the lide of me figure out the following.

 

I'm building an app on powerapps that I want to use to:

1. scan the barcode of a book

2. trigger the flow and search for the book details (author, title, publisher, cover image etc)

3. bring that data back to the app and display it on sceen <-- This is where I am stuck.

4. click a button to add those details to a library (excel sheet) using a second flow

 

I am running a search through the openlibrary API using the ISBN of a book that is scanned through powerapps. 

 

It takes the data into power automate and searches the API fine, but when it comes to translating the data I am flailing about and after hours of searching online I have give up. 

 

Once it gets the data on power automate through HTTP, I can't seem to figure out how to parse the json and get it to transfer back to powerapps - and I certainly can't figure out how to find and map it once it does get sent to powerapps!

 

Any help would be neat. Here is the flow and error:

Sami_lee_1-1707037796265.png

Sami_lee_2-1707037824444.png

 

Error:

Sami_lee_0-1707037769938.png

 

Json schema:

{
    "type""object",
    "properties": {
        "identifiers": {
            "type""object",
            "properties": {
                "goodreads": {
                    "type""array",
                    "items": {
                        "type""string"
                    }
                },
                "librarything": {
                    "type""array",
                    "items": {
                        "type""string"
                    }
                }
            }
        },
        "title": {
            "type""string"
        },
        "authors": {
            "type""array",
            "items": {
                "type""object",
                "properties": {
                    "key": {
                        "type""string"
                    }
                },
                "required": [
                    "key"
                ]
            }
        },
        "publish_date": {
            "type""string"
        },
        "publishers": {
            "type""array",
            "items": {
                "type""string"
            }
        },
        "covers": {
            "type""array",
            "items": {
                "type""integer"
            }
        },
        "contributions": {
            "type""array",
            "items": {
                "type""string"
            }
        },
        "languages": {
            "type""array",
            "items": {
                "type""object",
                "properties": {
                    "key": {
                        "type""string"
                    }
                },
                "required": [
                    "key"
                ]
            }
        },
        "source_records": {
            "type""array",
            "items": {
                "type""string"
            }
        },
        "local_id": {
            "type""array",
            "items": {
                "type""string"
            }
        },
        "type": {
            "type""object",
            "properties": {
                "key": {
                    "type""string"
                }
            }
        },
        "first_sentence": {
            "type""object",
            "properties": {
                "type": {
                    "type""string"
                },
                "value": {
                    "type""string"
                }
            }
        },
        "key": {
            "type""string"
        },
        "number_of_pages": {
            "type""integer"
        },
        "works": {
            "type""array",
            "items": {
                "type""object",
                "properties": {
                    "key": {
                        "type""string"
                    }
                },
                "required": [
                    "key"
                ]
            }
        },
        "classifications": {
            "type""object",
            "properties": {}
        },
        "ocaid": {
            "type""string"
        },
        "isbn_10": {
            "type""array",
            "items": {
                "type""string"
            }
        },
        "isbn_13": {
            "type""array",
            "items": {
                "type""string"
            }
        },
        "latest_revision": {
            "type""integer"
        },
        "revision": {
            "type""integer"
        },
        "created": {
            "type""object",
            "properties": {
                "type": {
                    "type""string"
                },
                "value": {
                    "type""string"
                }
            }
        },
        "last_modified": {
            "type""object",
            "properties": {
                "type": {
                    "type""string"
                },
                "value": {
                    "type""string"
                }
            }
        }
    }
}

 

Categories:
I have the same question (0)
  • Matthy79 Profile Picture
    4,180 Super User 2024 Season 1 on at

    Hello @Sami_lee 

     

    The error message is pretty clear and so is the screenshot you provided. You are not parsing a json.

     

    from the screenshots you provided I saw that you didn’t provide some keys for headers and query. Have you checked that?

     

    I would suggest you request it like this:

     

    https://openlibrary.org/isbn/YOURISBN.json

     

    and get rid of the rest.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 190 Super User 2025 Season 2

Last 30 days Overall leaderboard