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.
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
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
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!
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)
@renatoromao Hi. Are you able to help me understand this error?
@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!
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?
Let me know if you have any trouble.
Thank you.
That would be amazing!
Hi @Gwill1983 ,
I'll create a Flow template that contains this logic and I'll let you know in some minutes.