PVA in teams - Find a file in sharepoint library

(0) Share

Report

Posted on by Gwill1983

271

Hi all,

I am trying to implement a file search within my bot to allow users to ask the bot for a process document and the bot to then return the file (ideally) or a sharepoint link to the file.

Is this possible?

The user will not know the exact file name, but I see the PVA conversation as below:

User - Find Document

Bot - Document Name?

User - Warranty Process

Bot - Returns document named 'how to process a warranty return'

I have been struggling to get anywhere with this at all at the moment. I have trawled the web for solutions, but havent found anything massively relevant.

Any ideas or solutions would be most welcome.

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (10)

Answers (0)

Sort by

CU22081450-0 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gwill1983 ,

I'll create a Flow template that contains this logic and I'll let you know in some minutes.

Was this reply helpful? Yes No
Gwill1983 271 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you.

That would be amazing!

Was this reply helpful? Yes No
CU22081450-0 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

@Gwill1983 ,

Link: https://mtacbrasil-my.sharepoint.com/:v:/g/personal/renato_romao_mtac_org_br/ET3qxKXAor9MsiwN03bE5I4Bap26yH6JN07T2uf19UpS4g?e=e1tK8X

Let me know if you have any trouble.

Was this reply helpful? Yes No
Gwill1983 271 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for your help with this. Unfortunately it isnt working currently. It is coming up with the failure below at the filter array step:
The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@contains(item()?['Title'], triggerBody()['text'])' failed: 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string. The provided value is of type 'Null'.'.

Any ideas?

Was this reply helpful? Yes No
Gwill1983 271 on at

Like
a
(0)

Report
Copy link

Link copied!

@renatoromao not sure if you saw this. It feels like it is close!

The folder that I am referencing has sub folders which I thought might be causing the trouble, but I re-directed it to a folder with 1 file in to see if it found it and it came up with the same error.

Really struggling to correct this!

Was this reply helpful? Yes No
Gwill1983 271 on at

Like
a
(0)

Report
Copy link

Link copied!

@renatoromao Hi. Are you able to help me understand this error?

Was this reply helpful? Yes No
SShAl249 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gwill1983 Were you able to run this successfully. I am trying to search sub folders so that Power Virtual Agent bot comes up with relevant searches.

The method here by Glennbullion works to search, however, i'm unbale to limit to sub folders. Search share point for document - Page 2 - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Gwill1983 271 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi.
I didn’t ever manage to get this working, so abandoned the project after many, many hours of attempting to find a solution!

if you have better luck than me and find a solution then please let me know!

Was this reply helpful? Yes No
LucasConekta 11 on at

Like
a
(0)

Report
Copy link

Link copied!

I want to do something similar and can be the last file ordered by date that the very user/username who's chatting with the bot have uploaded to that specific SharePoint Document Library

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

Like
a
(1)

Report
Copy link

Link copied!

@Gwill1983 @LucasConekta
I've achieved something somewhat similar using the Graph API in PVA.
I had documented it here: https://powerusers.microsoft.com/t5/Calling-Actions-from-PVA/Calling-the-Graph-API-to-do-a-document-search-in-PVA/m-p/2101601#M1072

Was this reply helpful? Yes No