Power Platform Community Forum Thread Details

PVA Action many execution according user input

Hi everyone,

I´m doing a chatbot in Teams that make a kind of quiz to the users.
For each correct answer I have to create and item on a MS List (or even a line in a Excel table for example).
In the future, i´ll use that list to see the pontuation of each user.
My list have just 3 columns (name, question number and result (1 or 0))

The bot make the question and show three or four alternatives. If the user enter the correct answer, i call an action to create the item.

The problem is that the bot many times has some delay to show the next question and, if the user send many times the same answer (by copy and paste in the input field for example), the action is executed many times and i have more than one point for that user.

I tried:
1) To do a conditional to validate if that combination (name and question) already exist in the list. It doesn´t work. I belive because the Power Automate also have some delay.
2) another flow (outside the teams) that verify when an item is created and delete it if already exist the combination (name and question). It doesn´t work too.

I believe that one way to solute it, is creating the fields Name and Question like a Primary Key, however its not possible in MS List.

Does anyone have a tip?

Categories:

Flow Integration

Power Automate Flows

Quick Links

Leaderboard > Copilot Studio