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?