Skip to main content

Notifications

Calling Actions from Copilot Studio
Unanswered

SharePoint List

Posted on by

hello! I have a bot configured in Power Virtual Agents where it obtains items from a list in SharePoint through a flow created in Power Automate. The flow is working but a person has to write exactly what is on the sharepoint list for a response to come. Isn't there a way to establish a "like" to search for items in the list without the requester having to write exactly the same?

Categories:
  • Expiscornovus Profile Picture
    Expiscornovus 1,700 on at
    Re: SharePoint List

    Hi @Cardosovit,

     

    You would have a couple of options. You could for example use a substringof in your Filter Query. But that means part of the keywords need to match.

     

    If you are after fuzzy search type of logic I would recommend to make use of the Search of SharePoint/M365. You can interact with the Search REST API for that:

    https://learn.microsoft.com/en-us/sharepoint/dev/general-development/sharepoint-search-rest-api-overview

     

    In the below thread I shared an approach for this:

    https://powerusers.microsoft.com/t5/Building-Copilot-Studio-Chatbots/Search-share-point-for-document/m-p/1549570/highlight/true#M710

     

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,990

#3
Expiscornovus Profile Picture

Expiscornovus 1,700

Featured topics