cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vehicle8837
Regular Visitor

undefined

I am working on creating a chatbot that can get items from a SharePoint List through Power Automate. Currently, the bot can get items but only using the automatically assigned SharePoint List item ID. Is there a way to configure it such that it gets items using a different ID, like phone number?

3 REPLIES 3
renatoromao
Super User
Super User

Hi @vehicle8837 ,

 

You can use the "Get Items" action inside Power Automate and inside the OData filter you can use the query like PhoneNumber eq '9999999' . (PhoneNumber is a column inside the SharePoint list)

 

And you can see this topic: https://powerusers.microsoft.com/t5/General/Power-virtual-agent-insert-data-in-sharepoint-list-and-t...

 

Insert data into SharePoint

You can use Power Automate action to save rows inside the SharePoint list using this documentation:

https://docs.microsoft.com/en-us/connectors/sharepointonline/#actions

 

List items into PVA

You can use Power Automate action to get items inside the SharePoint list using this documentation

https://docs.microsoft.com/en-us/connectors/sharepointonline/#actions

After it, you can use Markdown to format items inside the Power Automate and send as outputs to show inside the PVA response

https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support#tables


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

I have used the get items and ODATA query. However, the response does not allow an apply to each loop. Is there a step by step tutorial on how to achieve this?

Hi @vehicle8837 ,

 

You can create an action of the beginning of your workflow called "Initialize variable" and the type String.

After your SharePoint action, create an action called "Append to string variable" adding your data to the Markdown (variable).

https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support#tables

 

And on the final of the workflow, you can send the variable to the Response.


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Virtual Agents Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Virtual Agents!

Users online (1,596)