Answered

Problem with sorting Lookup Column

(0) Share

Report

Posted on by JimmyKY

Hello-

I'm building a basic app that is based on data from a SharePoint list ("Customer Location List"). One column in the list is a "lookup" column ("Customer Name"), pulling data from another list.

My problem is sorting. Here's what I have for the sort function. I know "Title" isn't right. I have a label within the gallery that displays the customer name (ThisItem.'Customer Name'.Value). But I can't figure out what to change "Title" to in order to make the sort work.

SortByColumns(Filter([@'Customer Location List'],StartsWith('Customer Name'.Value,TextSearchBox1.Text)),"Title",If(SortDescending1,Descending,Ascending))

I'm new to this, so go easy on me. 😃

Thanks!

James

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Try:
Sort(Filter([@'Customer Location List'],StartsWith('Customer Name'.Value,TextSearchBox1.Text)),Title,If(SortDescending1,Descending,Ascending))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
JimmyKY 8 on at

Like (0)

Report

Sorry, maybe my question wasn't 100% clear.

"Title" is the default value for the sort function. I want to sort based on Customer Name'.Value.

I want to replace "Title" with Customer Name.Value. When I do (as shown below) it throws "Name isn't valid. The identifier isn't recognized".
SortByColumns(Filter([@'Customer Location List'],StartsWith('Customer Name'.Value,TextSearchBox1.Text)),Customer_x0020_Name'.Value,If(SortDescending1,Descending,Ascending))

I'm not sure how to get the sort ascending/descending to work with Customer Name.Value?

Thanks in advance,
James

Was this reply helpful? Yes No
JimmyKY 8 on at

Like (0)

Report

I should add: I understand that the column is a "lookup" column, so it's a structure, not a value. Can you sort ascending/descending on a structure? I would have thought "value" would have done it, but it does not.

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (0)

Report

Have you tried Sort:
Sort(Filter([@'Customer Location List'],StartsWith('Customer Name'.Value,TextSearchBox1.Text)),'Customer_x0020_Name'.Value,If(SortDescending1,Descending,Ascending))

Or
For SortByColumns, the column being sorted should be in quotes " "
Try and do that

Was this reply helpful? Yes No
JimmyKY 8 on at

Like (0)

Report

That worked, thank you!!!

Was this reply helpful? Yes No
alrezac on at

Like (0)

Report

Hi,

It looks like you were able to get an answer to your issue that you were having. I just wanted to pop in with a little more information if you would like to learn more. Feel free to take a look.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-sort

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No