The CreatorCon Call for Content is officially open! Get started here.

Power Automate query incident tickets being handled within the last 24 hours using ServiceNow API

makku22
Tera Contributor

Hi Everyone,
I have a slight similar to this case, but in my case I'm using Service Now API through Power Automate (as connector) and i just want to query the incident tickets being handled within the last 24 hours.


https://www.servicenow.com/community/itsm-forum/way-to-show-incidents-with-no-update-within-24-hours...


In the Query section in Service Now connector List Record action, I used assignment_group=12345dsftyrgh3454^system_updated_on>=javascript:gs.hours(24). These two combined queries didn't return any data, but if I test them individually/separately it works. By the way, this service Id that we used in Service Now API is a read only account, not sure if that's the cause. Could someone guide me the right direction?

6 REPLIES 6

makku22
Tera Contributor

Hope someone could help me on this, I badly need a solution for our daily and monthly reports. 😞

makku22
Tera Contributor

Anyone using Power Automate and encountered this issue?