Power Virtual Agent to fetch documents from Sharepoint

(0) Share

Report

Posted on by P_SA

220

Hello All ,

I am new to PVA , hence seeking suggestions.. Is it possible to create a bot which can send me the link to a specific document in Sharepoint ?

example : If i type " resource sheet " . it should fetch me the link where this document is located..

Need suggestions.. thanks in advance

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

jpirelli Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi! Through flow you can connect to sharepoint and return information, yes. I'd say get a simple bot working with a connection to MS Flow, from there, add in a sharepoint connector and there will be tons of possibilities!
https://docs.microsoft.com/en-us/power-virtual-agents/advanced-flow

Was this reply helpful? Yes No
P_SA 220 on at

Like (0)

Report
Copy link

Link copied!

@jpirelli Could you please help me with step by step procedure for my requirement ? I am struggling.

Was this reply helpful? Yes No
jpirelli Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

If you follow the link I gave to integrate with Flow, then you can follow something like this to build the flow:
https://powerusers.microsoft.com/t5/General-Power-Automate/item-link-to-open-word-online/td-p/111306

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!
Hi @P_SA . If you haven't had time to look at this already, here's some high level steps.

Create the Bot and the Topic
Add 'Call for action' and create the flow. Save the flow as it is.
Create a Solution and add the flow into that solution (now the flow will show up in PVA). https://docs.microsoft.com/en-us/power-virtual-agents/advanced-flow#move-a-flow-to-the-solutions-tab-on-the-microsoft-automate-portal
Update the flow and add the action "SharePoint - Get files" and save the property "Link to item" for the document you want. Pass that value back to PVA using the pre-built output string.
Let me know if you want more details or if this is enough to get you started!

Was this reply helpful? Yes No
chass Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

You might also consider just returning the link to the SP list item and emailing them the document -using a flow as suggested.

Was this reply helpful? Yes No