No Sort/Filter Data Table in UIPath

[annalyy (Anna)]

I am new to UIPath and while i am taking the learning and following the steps, I cannot find filter / sort data table from my list

Can someone please help? Thanks!!

[Manjuts90]

@annalyy for sorting and filter u have to use use .net commands

[akila93]

Hi @annalyy,
It available in the UiPath 2018.2 version not in below version

Release Notes

Refer below post to filter the data table.

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

For Example

dt.Select("[ColumnName]='Columnvalue'").CopyToDataTable()

[Prashant_08 (Prashant)]

“Sort Data Table” and “Filter Data Table” activities are available 2018.2 version onwards.
Try Updating your UiPath

[annalyy (Anna)]

Thanks all!

[LiannaZ (Lianna Zhang)]

Hi Prashant_08,
How to update UiPath? Is a dangerous move?
Many thanks!

[Prashant_08 (Prashant)]

How to update UiPath?
→ There are two types of installer

1. Windows installer (MSI).
2. EXE installer (EXE).
   The community version of UiPath updates automatically.
   In the case of Enterprise Edition, you need to have the installer of the specific version in order to update UiPath.

Is a dangerous move?
→ No. But you need to thoroughly test the workflow/process in the new version as well.

[LiannaZ (Lianna Zhang)]

Hi Prashant,

We are in Enterprise version and have be told our company later will update the version.

Our PC/desktop in very high security control, it doesn’t allow us to run the installation for community or others.

Many thanks for your quick response.

Keep in touch!

**EXT: 79211 Email: Lianna.Zhang@optus.com.au
**1 Lyonpark Road, Macquarie Park, NSW 2113 Australia

Lianna.Zhang@optus.com.au

This email may be confidential. If you received it accidentally, please delete it and let the sender know straight away so it won’t happen again. Please do not disclose this email to anyone else without the sender’s permission. We do our best to avoid errors on emails, but occasionally we do make mistakes, so we can’t warrant this email will be error free. And before you go, please note that we might scan, store, read or disclose to others, any emails sent to or from Optus at our discretion.

Please think of the environment before printing this email.

[LiannaZ (Lianna Zhang)]

Hi Prashant,

I am keeping get below error message, so I can’t login into orchestrator page.

I know you are expert on UiPath, Can you please help me?

Many thanks!

EXT: 79211 Email:
Lianna.Zhang@optus.com.au 1 Lyonpark Road, Macquarie Park, NSW 2113 Australia

Lianna.Zhang@optus.com.au

This email may be confidential. If you received it accidentally, please delete it and let the sender know straight away so it won’t happen again. Please do not
disclose this email to anyone else without the sender’s permission. We do our best to avoid errors on emails, but occasionally we do make mistakes, so we can’t warrant this email will be error free. And before you go, please note that we might scan, store,
read or disclose to others, any emails sent to or from Optus at our discretion.

Please think of the environment before printing this email.

[Prashant_08 (Prashant)]

I could see that you are trying to login to the default tenant. So try changing the tenant to your tenant Name.