Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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?

Dual Super User III
Dual Super User III

Have you considered storing the responses for the entire chat session inside the bot and then calling the flow at the end to record the results?  That should work better for the timing.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Center-of-Excellence-Starter-Kit-cropped 768x460.png

The Total Economic Impact™ of Power Virtual Agents

Read this 2021 commissioned study, conducted by Forrester Consulting.

Top Solution Authors
Top Kudoed Authors
Users online (2,701)