Announcements
I am trying to query service now ticket statuses from the PVA. How can I do this?
You can do this with a flow connector in PVA
https://docs.microsoft.com/en-us/power-virtual-agents/advanced-flow-create
and the ServiceNow Power Platform connector:
https://docs.microsoft.com/en-us/connectors/service-now/#get-record
I would recommend that you try using slot filling and a regex entity for your ServiceNow ticket id
https://docs.microsoft.com/en-us/power-virtual-agents/advanced-entities-slot-filling
Hello @treed779,
First of all, you create a topic so that the user can inform the number he wishes to consult, in servicenow the demands, requests and incidents are in different tables so make it clear what type of consultation the user can perform.Then build a Power Automate to effectively perform the query.You can do the status query in servicenow in two ways, using the native ServiceNow connector, where first you have to list the records in the table, passing as parameter the record number, here follows an example with an incident:
After the query all information related to the number searched will be available.
The second option, and the one I recommend, is via HTTP request, where you query your ServiceNow quickly and objectively.
To query from other tables just change the table name, the parameters are the same.
Did I answer your question?😉Please consider accepting it as the solution to help other members find you faster.
Like my answer?
Like it! 👍
Thanks!Diego Peres,Connect with me: Linkedin
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 820
Vish WR 327
Haque 296
