Unanswered

Built a PVA and need to link sharepoint documents

(0) Share

Report

Posted on by DEKEITH

Hello,

I am brand new to this and i have created a PVA bot. I been doing research and tried a few different ways to implement when a user asks a bot a for a document and searchs the sharepoint and returns back results that are similar to the documents they are looking for?

If anyone has any examples of step by to set up so I can get an Idea that would be greatly appreciated.

Also if anyone has an example for a topic that links or calls to the automate flow for an example too.

Categories:

General topics

I have the same question (0)

All responses (19)

Answers (0)

DEKEITH 29 on at

Like (0)

Report

Below is what I have setup so far. Any help would be appreciated.

Was this reply helpful? Yes No
jjustus 13 on at

Like (0)

Report

I'm having this same issue, I'm not sure when this changed, but on Newly created chatbots I no longer am seeing the hyperlink button when clicking within Topics like how it formerly appeared...I see that the above solution would likely work, but it seems like a massive amount of extra effort compaired to just having a hyperlink button like how the bots used to....see pics below

old chatbot:

new chatbot:

Was this reply helpful? Yes No
DEKEITH 29 on at

Like (0)

Report

Thanks @jjustus. I am shocked that there isnt much information on this or how to do it.

Was this reply helpful? Yes No
HenryJammes on at

Like (1)

Report

For links, you can use Markdown to format URLs as desired.
E.g. [Bing](https://www.bing.com) displays as Bing.

One way to search SharePoint and returns results to the user is to use Generative Answers:
Use content on SharePoint or OneDrive for Business for generative answers - Power Virtual Agents | Microsoft Learn

I also wrote that post on using the Graph API with PVA:
Solved: Calling the Graph API to do a document search in P... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
jjustus 13 on at

Like (0)

Report

Hello HenryJammes,

Could you expand further on how to use the generative answer? I'm not understanding what to enter in the 'input' section?

but --- why was the simple hyperlink button removed? it was so easy before and now this seems to be a weirdly cumbersome process just to simply have something linked?

Was this reply helpful? Yes No
DEKEITH 29 on at

Like (0)

Report

HenryJammes,

I made the flow and it runs successfully but I think I have the Tigger, actions in the topic wrong as it doesnt return the link of the document back. Can you take a look and see please? I replied back to my post. I ran my flow and it worked correctly but when testing with PVA Bot it didnt return back the sharepoint link of the document? Any help would be greatly appreciated.

The Flow(tested and works). Should the flow be automatic or instant?

Topic for PVA BOT

Was this reply helpful? Yes No
remidyon on at

Like (0)

Report

your trigger is correct: it will take the value from PVA and return a value after execution. What does the flow runs tell you when you check in power automate? Does it find a document? In your case you need to look at the flow run to understand what is happening (but you are on the right track)

Was this reply helpful? Yes No
DEKEITH 29 on at

Like (0)

Report

Remi,

below is the flow test just by it self with out the PVA

Here the PVA part it doesnt bring back any document link

Was this reply helpful? Yes No
HenryJammes on at

Like (0)

Report

Have you checked in the flow run that you actually return a URL to the PVA?
Can you also check the variable values at run time in PVA?
I suspect you're not returning a URL.

Was this reply helpful? Yes No
remidyon on at

Like (0)

Report

@DEKEITH I can see in your screenshot that the last step of your flow has a gray "X" icon on it - which means it was not executed: probably because previous step did not return any value. Can you expand each section of your flow run and see which step did not return the expected data? My guess is there is something wrong in the "get file" or the "apply to each" loop

Was this reply helpful? Yes No