#PowerAutomate – Flow to use Open Trivia Database questions in a Microsoft Teams bot 🤖 1/N

Hi !

A couple of days ago, I found a super cool connector in the Power Platform that allows us to get trivia questions from the Open Trivia Database.

I started to play around with the API, and hey, I created a bot that ask questions and present the options for the answers. Here is a couple of samples.

Q: In the first Left 4 Dead, you can play as either of these four characters.

trivia question sample in teams

Q: Which one of the following rhythm games was made by Harmonix?

Open Triviata Database API

OK, so let’s take a look at the API and the implementation. To get started using the Open Triviata Database API, use this URL:


This will return an amazing JSON with 2 questions, correct and incorrect answers, categories and more.

JSON API response with 2 questions, correct and incorrect answers, categories and more.
{"results":[{"category":"Entertainment: Television","type":"multiple","difficulty":"easy","question":"In the cartoon 'SpongeBob SquarePants', what did the acronym E.V.I.L stand for?","id":"1086","correct_answer":"Every Villain Is Lemons","incorrect_answers":["Every Villain Is Lemonade","Every Villain Is Limes","Each Villain Is Lemonade"]},{"category":"Sports","type":"multiple","difficulty":"easy","question":"Which city did the former NHL team "The Nordiques" originiate from?","id":"2779","correct_answer":"Quebec City","incorrect_answers":["Houston","Montreal","New York"]}]}

This is super cool, and also is a great starting point for a Power Automate Flow. In next posts, I’ll explain how I created this.

Power Automate to use Open Trivia Database questions in a teams bot

And important: Join me in this 2-week FREE program @MSFTReactor
and we will learn together about Microsoft Power Pages.
We will also cover fundamentals of Power Pages architecture, components, features, and tooling.


Starting on Dec 05 😀

Happy coding!


El Bruno

More posts in my blog ElBruno.com.

More info in https://beacons.ai/elbruno


Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: