You’re offline. This is a read only version of the page.
2
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?
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.
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-then/m-p/619240
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
#1
Pablo Roldan
49
#2
Romain The Low-Code...
35
#3
stampcoin
10
Share
Report
All responses (
Answers (
