Skip to main content

Notifications

Announcements

No record found.

Topic Creation & Management
Unanswered

Looking to query service now from the bot

Posted on by

I am trying to query service now ticket statuses from the PVA. How can I do this? 

Categories:
  • DiegoPeres Profile Picture
    DiegoPeres 327 on at
    Re: Looking to query service now from the bot

    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: 

     

    DiegoPeres_4-1660587945154.png

     

    DiegoPeres_5-1660588074818.png

     

     

    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.

    DiegoPeres_2-1660587211739.png

     

    DiegoPeres_1-1660587154517.png


    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

     

  • peterswimm Profile Picture
    peterswimm on at
    Re: Looking to query service now from the bot

    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

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,954

#3
Expiscornovus Profile Picture

Expiscornovus 1,648

Featured topics