cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GustavoDuarte
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?

1 REPLY 1
Pstork1
Dual Super User
Dual Super User

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

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

Top Solution Authors
Top Kudoed Authors
Users online (1,087)