# Sort Data Table does not give expected result

**URL:** <https://forum.uipath.com/t/sort-data-table-does-not-give-expected-result/227061>\
**Category:** Help\
**Tags:** system, activities\
**Created:** [May 29, 2020, 7:03am UTC](https://forum.uipath.com/t/sort-data-table-does-not-give-expected-result/227061 "2020-05-29T07:03:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![atomic](https://avatars.discourse-cdn.com/v4/letter/a/c5a1d2/32.png) [@atomic](https://forum.uipath.com/u/atomic)\
**Post date:** [May 29, 2020, 7:03am UTC](https://forum.uipath.com/t/sort-data-table-does-not-give-expected-result/227061/1 "2020-05-29T07:03:52Z")

</div>

I put the “Order” to Ascending and i get this:  
 ![image](https://global.discourse-cdn.com/uipath/original/3X/6/8/684ce153269333a05240c9d523247ac5f2f7799e.png)

---

<div class="post-metadata">

**Author:** ![samir](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/samir/32/84380_2.png) [@samir](https://forum.uipath.com/u/samir)\
**Post date:** [May 29, 2020, 7:08am UTC](https://forum.uipath.com/t/sort-data-table-does-not-give-expected-result/227061/2 "2020-05-29T07:08:22Z")

</div>

Hi @atomic,

try this

SortedDT =

```auto
DT.AsEnumerable().OrderBy(Function (f) CInt(f(“ColumnName”))).ToArray.CopyToDatatable

```

put your column name instead of “ColumnName” in above code.

---

<div class="post-metadata">

**Author:** ![jhj3627](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jhj3627/32/178773_2.png) [@jhj3627](https://forum.uipath.com/u/jhj3627)\
**Post date:** [May 29, 2020, 7:12am UTC](https://forum.uipath.com/t/sort-data-table-does-not-give-expected-result/227061/3 "2020-05-29T07:12:42Z")

</div>

Hi.  
How about changing the expression style on excel?  
to number

---

<div class="post-metadata">

**Author:** ![atomic](https://avatars.discourse-cdn.com/v4/letter/a/c5a1d2/32.png) [@atomic](https://forum.uipath.com/u/atomic)\
**Post date:** [May 29, 2020, 7:36am UTC](https://forum.uipath.com/t/sort-data-table-does-not-give-expected-result/227061/4 "2020-05-29T07:36:22Z")

</div>

Thank you, it works great!

Why does your solution work but the “Sort Data Table” activity doesnt?

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\
**Post date:** [June 1, 2020, 7:36am UTC](https://forum.uipath.com/t/sort-data-table-does-not-give-expected-result/227061/5 "2020-06-01T07:36:26Z")

</div>

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.