Skip to main content

Notifications

Power Platform Community / Forums / General / Power Virtual Agent to...
General
Answered

Power Virtual Agent to fetch documents from Sharepoint

Posted on by 6

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:
  • chass Profile Picture
    chass on at
    Re: Power Virtual Agent to fetch documents from Sharepoint

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

     

  • Verified answer
    Re: Power Virtual Agent to fetch documents from Sharepoint

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

    1. Create the Bot and the Topic
    2. Add 'Call for action' and create the flow. Save the flow as it is.
    3. 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
    4. 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!

  • jpirelli Profile Picture
    jpirelli on at
    Re: Power Virtual Agent to fetch documents from Sharepoint

    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 

  • P_SA Profile Picture
    P_SA 6 on at
    Re: Power Virtual Agent to fetch documents from Sharepoint

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

  • jpirelli Profile Picture
    jpirelli on at
    Re: Power Virtual Agent to fetch documents from Sharepoint

    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 

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,968

#3
Expiscornovus Profile Picture

Expiscornovus 1,673