Flow Designer - Lookup Records - order by

Averell
ServiceNow Employee
ServiceNow Employee

(Madrid instance) Is there a way to lookup records by an order? I need to attach a list of task in a certain sequence.

I need an order by and a sort ascending/descending selection.

It looks it is not available. Is there a way to do this via an action and a script? But how to pass back a list??

1 ACCEPTED SOLUTION

Sebastian R_
Kilo Sage

Hi,

even if your post is a little bit old. I was facing the same issue today. It is possible to to it via a custome action with an script.

As output of your script action you can select the type "Records" and your table.

 

I also submitted an enhancement request. The sort feature is currently a candidate for the New York Release.

 

find_real_file.png

View solution in original post

6 REPLIES 6

In my example the type was a Condition. If you are on New York Release I recommend using the new OrderBy functionality withing "Look Up Record" action.

I think your solution is still applicable if someone (like me) needs the output ordered by multiple columns... It's a shame the list view multiple sorting option is not available in FD...