Flow Designer - Lookup Records - order by

[Averell]

(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??

[Sebastian R_ · Accepted solution]

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.

[pooja V1]

Hello Sebastian,

Can you please let me know if this sort functionality is available in New York release?

Thanks,

Pooja

[Sebastian R_]

Yes the orderBy functionality is included in New York Release (https://docs.servicenow.com/bundle/newyork-servicenow-platform/page/administer/flow-designer/referen...)

[pooja V1]

I was trying to use this solution to fix by issue. I am bit confused what should be the input variable. Can you please help me?