Skip to main content

Notifications

Copilot Studio - Topic Creation & Management
Unanswered

Power Virtual Agent Bot(Chat bot) to search for keyword in sharepoint list

(0) ShareShare
ReportReport
Posted on by 2

Hi All,

 

Below is my requirement.

 

1. User will initiate the chatbot.

2. Get the user input.

3. Identify the keywords

4. connect to SharePoint list - SharePoint list will have 2 columns (keywords, Description)

5. Search for the keywords in SharePoint list and get the associated description

6. Display results(description) back to user in power Virtual Agent

 

Everything can be done but not sure how we can identify the keyworkds from user input.

Example User Input: What is the contact email and phone number?
Keworkds: contact email, phone number

Note: I want to use Power Virtual Agent for interaction.

 

Appreciate the help!.

 

Thanks,

Balakrishna Reddy. C

Categories:
  • nikviz Profile Picture
    nikviz 242 on at
    Re: Power Virtual Agent Bot(Chat bot) to search for keyword in sharepoint list

    I did something with excel as I dont have access to sharepoint. But the same can be replicated in sharepoint.
    Dataset containing Keywords and Description

    nikviz_0-1677842919617.png

     

    Create a Topic

    nikviz_1-1677842991949.png

     

    Logic to be used in power automate:

    nikviz_2-1677843502687.pngnikviz_3-1677843553191.pngnikviz_4-1677843584949.png

     

    Sample Demo:

    nikviz_5-1677843957502.png

     

    If you have too many keywords, then I would suggest to use "contains" function in power automate or Azure Function App to parse through the keywords.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics