Is it possible to sort items on Map component?

[mihamocnik]

Hello!

Is there any way to sort items on Map component? I tried with Sort by columns but without any effect. Just want to see items by created on ascending. Please advise

BR,

Miha

[v-bofeng-msft]

Hi @mihamocnik ,

Please set the Map's Items property to:

With({SortTheTable:Sort(CheckIn,createdon)},
  ForAll(Sequence(CountRows(SortTheTable)),Patch(Last(FirstN(SortTheTable,Value)),{Rank:Value}))
)

and then set it's ItemsLabels property to:

"Rank"

Best Regards,

Bof

[mihamocnik]

Hi Bof,

I tried & also added ascending but without any success:/ current location (Frodx) should be 1 since it was created as first record. I have also list on the other screen which is okay to be as descending.

Map:

List:

Is there any bug in the system?

BR,

Miha

[v-bofeng-msft]

Hi @mihamocnik ，

Did you set the Map's ItemsLabels property to:

"Rank"

?

Please try:

With({SortTheTable:Sort(Filter(CheckIn,'Created On'=Today()),createdon,Descending)},
  ForAll(Sequence(CountRows(SortTheTable)),Patch(Last(FirstN(SortTheTable,Value)),{Rank:Value}))
)

 or

With({SortTheTable:Sort(Filter(CheckIn,'Created On'=Today()),createdon,Ascending)},
  ForAll(Sequence(CountRows(SortTheTable)),Patch(Last(FirstN(SortTheTable,Value)),{Rank:Value}))
)

Best Regards,

Bof

[mihamocnik]

Hi Bof,

Tried all but it is still the same:/

Descending

Ascending

Items label

[v-bofeng-msft]

Hi @mihamocnik ,

Could you please show me the data table?(Save the data into a collection named test collection and show me the value please)

ClearCollect(
  TestCollection,
  ShowColumns(
     With({SortTheTable:Sort(Filter(CheckIn,'Created On'=Today()),createdon,Ascending)},
         ForAll(Sequence(CountRows(SortTheTable)),Patch(Last(FirstN(SortTheTable,Value)),{Rank:Value}))
     ),
     "createdon",
     "Rank"
)

Best Regards,

Bof

[mihamocnik]

Hi Bof,

it shows ascending 

BR,

Miha

[v-bofeng-msft]

Hi @mihamocnik ,

Did you find the "Rank" column?

Best Regards,

Bof