web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Can't extract data fro...
Power Automate
Unanswered

Can't extract data from ServiceNow

(0) ShareShare
ReportReport
Posted on by 2

Hi, my intention is to extract a list of ticket from a ServiceNow query (query already contained in the URL).
The problem is that power automate is not grabbing the column where I have to right click in order to select "export to excel"Capture.JPG

I've tried "Get details of web page" and CTRL+click but it doesn't see the column.
I haven't installed ServiceNow plugins. Thanks for your help!

Categories:
  • lbendlin Profile Picture
    8,726 Super User 2026 Season 1 on at

    Why not use the ServiceNow API?

  • symon75 Profile Picture
    2 on at

    I've tried to use servicenow connector but I receive a "User not authorized" message. As the URL itself generates the query that I need in order to extract data, is there a workaround (or a way to use servicenow API) that let me export data automatically?

  • lbendlin Profile Picture
    8,726 Super User 2026 Season 1 on at

    We ended up creating a custom connector that covers the majority of the SNOW queries, and also allows the developer to specify arbitrary search parameters. Works fine on desktop, but in the service (with gateways) it is still reluctant to properly authenticate.

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 263

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard