lookup control list from sharepoint not alphabetized

[shugs]

Hi,

I have a problem in my app with the EditForm generated from a sharepoint list (called 'Hours') in which I have a lookup field based on another sharepoint list 's column (called 'Project') containing the projects' names. The aim  is to select a project from the dropdown list of project names to associate with the work hours that are entered in another datacard. Now, the display of my sharepoint list 'Project' alphabetizes the projects by their name and when I enter work hours in the sharepoint 'Hours', the dropdown list of project names is correctly displayed (in alphabetical order). But when I'm using the app, the dropdown list of project names, in the EditForm of the sharepoint list 'Hours', displays the project list in the order I entered them. Does anyone have any idea on how I can fix this and get the list in alphabetical order?

Many thanks!

[KC]

Hi Shugs,

If you haven't already, try the Sort function.

https://powerapps.microsoft.com/en-us/tutorials/function-sort/

[shugs]

Hi KC,

I don't have any item field in the EditScreen generated from my sharepoint or in the DataCard or DataCardValue in question. To what should I apply it?  

[Tom_Slosse]

Hey @shugs

You could use SortByColumns(<datasource>, "<SharePointFieldToSortOn>", If(SortDescending1, Descending, Ascending))

Hope this helps.

Kind regards

Tom

[shugs]

Hi Tom_Slosse,

I wanted to use the autogenerated control for this but there is no access to the items. I tried creating a new control in my form and using the formula you mentionned but that is not working either. As I said, the order in the dropdown diplayed in sharepoint is correct but not in powerapp. I'm starting to think this might be a bug.

[shugs]

Correction : I managed to to sort those by creating a new control. Still interested in finding a solution for the autogenerated controls.

[shugs]

Still haven't found a solution to my problem : I'll try to rephrase it.

I have an EditForm generated from a sharepoint list Hours. In Hours, I have a Research column which is giving a choice between different project listed in another sharepoint Project. The projects listed in Project are ordered by alphabetical order as well as  in the dropdown list displayed in Hours. Now when I generate an EditForm from this, the dropdown list in the app (DataCardValue) lists the projects by the order in which they were entered in Project.

The autogenerated dropdown control in the EditForm (DataCardValue), corresponding to the Research column in Hours, doesn't contain any item field allowing to sort the choices, as suggested by @KC and @Tom_Slosse. I tried to work around the problem by inserting a new DropDown control with items sorted from the Project list, but I couldn't figure how to get this accepted in the EditForm for the sharepoint Hours.

Any help?

[shugs]

Clearer problem explanation and answer in another post.