Flow Designer - Lookup Records - order by

AverellP · ‎03-01-2019

(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_ · ‎06-26-2019

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.

View solution in original post

Sebastian R_ · ‎04-16-2020

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.

marekmerese · ‎01-03-2025

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...

Peter Halsema · a week ago

Marek, have you already found a solution on this? I tried with scripted, but that didnt work out.

I otherwise am forced to create a new table-field in which I place my own multiple-sort. and then I can sort on that field.