Need access to a database of books? Google Books API is a good source.
You can run an HTTP request to Google Books API. If you do not like playing with JSON, this flow takes care of the hard work for you.
- I flatten, or pancake, the results that come back from the API so that there are no complex fields.
- I filter out entries without an ISBN number
All you need to do is supply an API key and you just need to wire this up to Power Apps and make it work like any other connector.
Some additional ideas for you to customize
- Copy the same flow for Power Virtual Agents. A bot can look up the information that is queried. You can add additional actions like selecting the first result and drilling into the desired field.
- Create an app for cataloging your books!
Instructions
- Import the .zip file.
- Get an API key to Google Books API. See Get Started: https://developers.google.com/books/
- Paste the API key into the flow or use another pattern to retrieve the key.
- Add the flow to an action in Power Apps.
