How can I use a chatbot answer from Sharepoint as a new question in the chat?

(0) Share

Report

Posted on by eafuertes1

Hi everybody, hope u doing well...

I'm currently working in a chatbot for my company and I have a question to be solved. Hope anyone can help me 😁

I´m following this structure to make my bot work.

I start with the trigger phrases in my case as an example is "Base".
Then the chatbot presents two options that will be searched in the SharePoint and the user selects one of them. In this case these options are: "Matrícula" and "Retiro", I will select Matricula as an example.
Once selected the option, the chatbot will look up in the Sharepoint for the answer and when found it will give back the answer to the user. Here is the flow.

Flow Flow

And the result in the chatbot is something like this:

Captura de Pantalla 2022-08-15 a la(s) 17.23.35.png

The structure in my excel file is very simple, just like this:

Captura de Pantalla 2022-08-15 a la(s) 17.26.23.png

So, when the chatbot recognize the selected option it searches the answer in the Sharepoint file, and now it gives back the column "B" Questions as the answer. However, What I need is to give back these values (Questions) as new options to the user to be selected in order to present the user the "real" answer in column "C". Is it possible?

I'm using this workflow because I want to make a webpage where I can update the questions and answers in the SharePoint and and the same time update automatically the chatbot. If not possible is there any other way to do it?

Thanks very much for your help.

Ps. sorry for my english. 😁

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

DiegoPeres 327 on at

Like (0)

Report

Hi @eafuertes1

I am using something like this, for common and simple questions that don't require much validation in order to create fewer topics within the bot.
However, I recommend using SharePoint lists and not Excel files.
Create a structure in the list as you did in excel, create the entries in your flow inside the BOT.
When one of the options is accessed, you create a power automate, searching the list according to the question and returning the answer related to that question.
But the only thing that remains of simple change is the answer, because if you have a new question you need to insert it in the option for the user, exactly as you registered it in the list, so your encounter will always be the question.
I hope to have helped you

Did I answer your question?😉
Please consider accepting it as the solution to help other members find you faster.

Like my answer?

Like it! 👍

Thanks!
Diego Peres,
Connect with me: Linkedin

Was this reply helpful? Yes No
eafuertes1 2 on at

Like (0)

Report

Hi Diego,

Thanks for your help, I'm gonna try this way now and I'll let you know how is it going!

Was this reply helpful? Yes No
Sharmilshah 28 on at

Like (0)

Report

Hello @DiegoPeres I am looking for the solution to similar problem and I am trying to get both questions and answers pulled by Power Automate from SharePoint lists. Is there a way around it? I want to create a clickable options based on keyword given by user.

Example: Chatbot asks keyword> PA searches keyword in questions list in SharePoint lists > PA sends the relevant questions based on keyword> User clicks on a question> PA gives the answer.

Was this reply helpful? Yes No