cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Strange error with "Sort by Column"

Hi guys.

I'm trying to sort one column by another using the "Sort by Column" feature in the Data Section.

I created an "ORDEM" column that has no repeated values (guaranteed by Row_number () Over clause on my Oracle database), but I still get an error. I want order "MERCADO" by column "ORDEM"

To be sure, I also applied a "Removed Duplicates" to the column by PowerQuery, but I still get the same error.

 

DataDataErrorErrorWhat I wantWhat I want

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Re: Strange error with "Sort by Column"

Hi @viniciusosousa 

 

The column to be used as the "sort by column" must contain at most one distinct value for each value in the column to be sorted.

To make this work, you would need to set up ORDEM so that it (for example) contains 1 for MERCADO = 'BR', 2 for MERCADO = 'other value' and so on.

 

Regards

Owen


Owen Auger

Did I answer your question? Mark my post as a solution!

Connect on Twitter
Connect on LinkedIn

View solution in original post

2 REPLIES 2
Highlighted
Super User I
Super User I

Re: Strange error with "Sort by Column"

Hi @viniciusosousa 

 

The column to be used as the "sort by column" must contain at most one distinct value for each value in the column to be sorted.

To make this work, you would need to set up ORDEM so that it (for example) contains 1 for MERCADO = 'BR', 2 for MERCADO = 'other value' and so on.

 

Regards

Owen


Owen Auger

Did I answer your question? Mark my post as a solution!

Connect on Twitter
Connect on LinkedIn

View solution in original post

Highlighted
New Member

Re: Strange error with "Sort by Column"

Works like this @OwenAuger ! Tks

 

image4.png

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors