Sortbycolumn not working

(1) Share

Report

Posted on by nchandran

426

Can someone guide me on this. i got a dropdown menu that i want to set the items.

It supposed to drop down the list based on department, i;ve tried department.value. 'Department' or "Department" but its not retrieving the data from the sharepoint list. Captured below are my screenshots. It works fine if i use SortByColumns('Leslie New Sharepoint List',"Full_x0020_Name")

Department sortbycolumns.jpg Temp table.jpg

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @nchandran ,
Try this
SortByColumns( AddColumns( ’Leslie New Sharepoint List’, "DeptSort", Department.Value ), "DeptSort" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
nchandran 426 on at

Like (0)

Report
Copy link

Link copied!

hi,

its not working,

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @nchandran

In SharePoint, could you please click on your Cog (top-right), then choose list settings,

then scroll down until you see the column name and click on it

now, inside your address bar you will see at the end the name of the column as SharePoint sees it - this is what we use when we reference SharePoint columns using " " which is what SortByColumns requires:

Could you try using that name after &Field= in your SortByColumns quotes " " and let me know if that works?

Thanks,

Sancho

Was this reply helpful? Yes No
nchandran 426 on at

Like (0)

Report
Copy link

Link copied!

this is the screenshot of the sharepoint column which im targetting.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@nchandran ,
You have put Filter in front of it - it does not need this.

Was this reply helpful? Yes No
nchandran 426 on at

Like (0)

Report
Copy link

Link copied!

ok i've removed filter but the dropdown is not working.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @nchandran ,
My code is a complete workaround as you cannot sort by a Choice field. I got the code you have working, but needed to save it and come back for it to update.
If you really need SortByColumns (to reference other fields directly rather than by Lookup), I think this is the only option.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @nchandran ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

nchandran 426 on at

Like (1)

Report
Copy link

Link copied!

Hi,
I found out that i had to change the properties value to Deptsort inorder to see the results. Thank you soo much!!!
I got this working but there are mutiple duplicates, so i've decided to add a distinct feature on it. Works great.
Distinct(SortByColumns(AddColumns('Leslie New Sharepoint List',"DeptSort",Department.Value),"DeptSort"),DeptSort)

Was this reply helpful? Yes No