I’m trying to sort a table based on a relation look up item. I see that this isn’t possible. How do I turn the look up item into something I can sort by?
Use a Query column instead of a relation. It has a sorting option.
Sorry, I think I explained wrong. I’m wanting to sort on the Layout side of things based on a location that is in a look up item from a relation. Not sorting on the actual data table.
As long as the relation is the source of the collection, you can sort the collection based on the data in that relation. You don’t need the lookup column.
So you have a table, and in that table there’s a lookup column. You want to sort by that column but that isn’t possible?
Any chance you’re using a Big Table? Or the relation you have is a multiple match column?