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

Lookup records is not producing records with Sys_id

Allen12
Tera Guru

I am doing a lookup from List Collector using sys_id. Flow Sees the IDs selected, however its not finding them in the tabe.  Any suggestions?  Let me know if you need more of the flow.

Allen12_0-1724768551997.png

 

1 ACCEPTED SOLUTION

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

The condition looks a bit odd. I wouldn't expect sys_idLIKE (like = contains), I would have expected sys_idIN (in = is one of). Sys_id contains and then two sys_ids with a comma, that wouldn't realistically match right?

 

You can also verify yourself on the list of that table, though I guess you will face the same outcome.

 

So try to change the condition.

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

View solution in original post

2 REPLIES 2

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

The condition looks a bit odd. I wouldn't expect sys_idLIKE (like = contains), I would have expected sys_idIN (in = is one of). Sys_id contains and then two sys_ids with a comma, that wouldn't realistically match right?

 

You can also verify yourself on the list of that table, though I guess you will face the same outcome.

 

So try to change the condition.

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

Allen12
Tera Guru

Thank you that was it.  "Is one of"