cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VeeLearnMSFT
Helper V
Helper V

PVA Teams Chat Bot - Search File in Sharepoint File Library and Return Link or File

 

I have to admit, I am completely clueless.  I created a flow that triggers what file do you want to search for.  Just before I start.  We do not have any advanced licensing here, we just have the bare bones in our organization and maybe this is the limiting factor here but I could not figure out a way for it to call to sharepoint and return back a file.

 

VeeLearnMSFT_0-1651090094050.png

 

When I press the call to action and select Power Virtual Agent Template.  I am not sure where to go from here.  The flow would would get the persons name or last name.  It would search the file librare in sharepoint, it would return files that resemble what the person asked. It may not be exactly but close and return the files or the link to the files. Not sure I am thinking out loud here. 

 

This is what comes up when I click on call to action. 

 

VeeLearnMSFT_1-1651090209168.png

 

this is what I get when I search for Sharepoint.  Any guidance would be awesome!

 

 

2 REPLIES 2
Expiscornovus
Dual Super User
Dual Super User

Hi @VeeLearnMSFT,

 

I would suggest to have a look at the video in this thread, created by @renatoromao

https://powerusers.microsoft.com/t5/Calling-Actions-from-PVA/PVA-in-teams-Find-a-file-in-sharepoint-...

 

That video has a good setup for a flow which gets files from a library.

 

Here are my detailed steps.  Am I following it correctly?

VeeLearnMSFT_0-1651162293061.png

Another screenshot of files in sharepoint.  The files are contained in subfolders, if that makes a difference:

VeeLearnMSFT_9-1651162746597.png

 

What I am trying to do is search all of those folders for the name smith.  These are PDF files in the naming standard of 1234567_Smith.  Numeric underscore and last name.

 

Here is my bot:

VeeLearnMSFT_1-1651162380227.png

 

Here is my flow:

VeeLearnMSFT_2-1651162442149.png

1. 

VeeLearnMSFT_3-1651162460148.png

 

2. 

VeeLearnMSFT_4-1651162473748.png

 

3.

VeeLearnMSFT_5-1651162554835.png

4.

VeeLearnMSFT_6-1651162574781.png

5. 

VeeLearnMSFT_7-1651162592841.png

6. 

VeeLearnMSFT_8-1651162609975.png

 

Can you see what I am doing wrong?  As I am getting an error with this process:

VeeLearnMSFT_10-1651162773590.png

I just started to use this so this is a bit daunting.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

Top Solution Authors
Top Kudoed Authors
Users online (2,798)