Unanswered

sharepoint list and chatbot

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

So for a school project I have been working on a simple database using SharePoint and Teams as the front-end. Currently I am unable to use Azure applications to solve problems (due to costs), so I have been using SharePoint list and documents as a small database. The clients have asked me to implement a search option on this data. As a solution to this, I would want to use the MS Chatbot from PVA to "filter" the SharePoint list data. Using the chatbot to give the user multiple choice options used in the SharePoint list.

I have a hard time working out the logic of combining the input from the chatbot to the input of a flow and receiving back data via the flow back to the chatbot.

In short, I would like to filter the data from the SharePoint list to give the users a list of documents (which are in the same SharePoint list) based on the implemented filter. So, for example, the chatbot gives the user the option to filter the data on difficulty: Basic, Intermediate or Advanced (in the Sharepoint list a column). And via a flow, the chatbot will give a list of all the related documents (another column in the same SharePoint list).

Giving the user optionsreading the option, sending input to the flow(above this Power Virtual Agents, title: Level)

If you have any thoughts, tips or suggestions on how I can solve this, please reply. Other solutions/advice on how to solve this problem are equaly welcome.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

A simple approach would be to use the value column from the Get items action in your flow and put that in the return value LevelOutput column.

However, I guess you want some additional mark-up and only select specific columns from that list, is that correct?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi all,

So I got stuck with the previous approach and started to use this example:
https://www.catapultsystems.com/blogs/use-microsoft-power-virtual-agent-to-get-data-from-sharepoint/
However, this new flow is not recognizing the output and I'm not sure if my 2nd variable is filled in correctly.

The rest has been filled in as in the example, only changing some variable names.

Is there a simple solution to get a output that I can then use in the chatbot?

Many thanks in advanced.

Was this reply helpful? Yes No
jcody 6 on at

Like (0)

Report

Did you ever get this to work.

We want the Power Virtual Agent chatbot in teams when asked a question such as "Show me a report in the XYZ Category"
it can search the sharepoint list for XYZ Categories and ask - for a 2nd input OR display the options...
for Report Name and the 2nd column (report link) or (report description).

Was this reply helpful? Yes No