PowerAutomate – Flow to use Open Trivia Database questions in a Microsoft Teams bot 🤖 Series
- Intro to Open Trivia Database API
- How to process the API Response and send a question to Teams
- How to validate the user response in teams with the Trivia Question correct answer
- Sort and mix the possible answers to the question
Hi !
In previous posts we request a Trivia quesion using the Open Trivia Database API, and sent the question as a message using Teams Flow Bot.
Context
The process of the quesion is fine, however, the way that we process the answers has a flaw. Let’s take a look at steps in the current flow.
- Initialize an array variable [arrAllAnswers] with the array of incorrect answers.
- Add the correct answer to the array.
![Initialize an array variable [arrAllAnswers] with the array of incorrect answers.
Add the correct answer to the array.](https://brunocapuano.files.wordpress.com/2022/11/image-15.png?w=629)
Solution
Once you answer a couple of questions, you may detect that the correct answer is always at the end. It’s time to think for a creative solution.
At the beggining I think in a weird solution: we have several options to work with arrays, so we may create a series of steps to mix the array.
At the end, I choose to use the simple solution: sort the array. Yes, we have a sort function, and that will be enough.
With this approach, we will always have the question possible answers sorted alphabetically.
Examples
Let’s take a look at a couple of examples
A true – false question
A 4 possible answers question, using countries !
\We are almost there ! However, we can improve still this flow a lot 😀
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.
https://aka.ms/DecPowerPagesBootcamp
Starting on Dec 05
Happy coding!
Greetings
El Bruno
More posts in my blog ElBruno.com.
Top comments (0)