cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dracu808
New Member

How to display sharepoint List row with PVA?

i have list of employee info and i want the chatbot to display Person info based on what the user supply for example:

the user types his : PC mac address or ip address or name or EMP ID and then the BOT searches the list for matches

then display that row 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @Dracu808,

 

You could use a Get Items action in Power Automate flow for this and use a filter query. 

 

Alternatively you could also a API search query.

 

Below is an example of that approach.

The ListPath would be something like this:

https://contoso.sharepoint.com/sites/YourSiteName/Lists/YourListName/

 

_api/search/query?querytext='@{triggerBody()['text']}+Path:@{variables('ListPath')}'

 

listpath_searchquery.png

View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

Hi @Dracu808,

 

You could use a Get Items action in Power Automate flow for this and use a filter query. 

 

Alternatively you could also a API search query.

 

Below is an example of that approach.

The ListPath would be something like this:

https://contoso.sharepoint.com/sites/YourSiteName/Lists/YourListName/

 

_api/search/query?querytext='@{triggerBody()['text']}+Path:@{variables('ListPath')}'

 

listpath_searchquery.png

View solution in original post

nice thanks alot

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,728)