web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Power Virtual Agent Bo...
Copilot Studio
Unanswered

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

(0) ShareShare
ReportReport
Posted on by cbkreddy_107 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:
Topic creation & management
I have the same question (0)
  • nikviz Profile Picture
    nikviz 242 on at

    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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the January Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 161

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 130 Super User 2026 Season 1

#3
Arild Aarnes Profile Picture

Arild Aarnes 61 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt
Welcome to the Copilot Studio forum!

Product updates

Microsoft Power Platform Community release plans