cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Sort Distinct Dropdown Issue

Hi Guys,

Im having an issue. I want users to be able to use a drop down to select a job number from my table. I also want the drop down to not display any duplicate values. The final thing i want from my drop down is to sort it so the numbers are in order. I am able to show distinct values successfully and when I preview the app it is sorted correctly. However when i publish the app I recieve an error saying "Server Response: The column 'Result' of the table wasnt found". I thought that my dropdown would create a column called Result that i could use. Please let me know if i am mistaken.

 

Here is what i have for my dropdown ITEMS=Sort(Distinct('[dbo].[JCM_MASTER__COMMITMENT]',Job),Result)

 

 

Thank You!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate I
Advocate I

Re: Sort Distinct Dropdown Issue

This is a known issue with Power Apps. For fix: 

Go to File-App Settings - Advanced settings and turn off the Explicit column selection. Make sure to save and signout before opening. 

 

Thanks!

View solution in original post

2 REPLIES 2
Highlighted
Advocate I
Advocate I

Re: Sort Distinct Dropdown Issue

This is a known issue with Power Apps. For fix: 

Go to File-App Settings - Advanced settings and turn off the Explicit column selection. Make sure to save and signout before opening. 

 

Thanks!

View solution in original post

Highlighted
Frequent Visitor

Re: Sort Distinct Dropdown Issue

This worked thank you!

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,424)