Unanswered

Datable filter

Like (1) Share

Report

Posted on 5 May 2021 11:33:06 by Community Power Pla...

Hi i have a scenario where I have a datable and i need to filter a column based on some values and move to corresponding datatables. Can anyone please help how to filter datatable based on column values and assign them to different datatable.

All responses (7)

Answers (0)

drkeek 35 on 29 Jun 2021 at 15:53:13

Like (0)

Report

Re: Datable filter

@Anonymousthank you.

Feels like added complexity to me but certainly looks like an option.
Riyaz_riz11 2,666 Super User 2025 Season 1 on 29 Jun 2021 at 14:43:02

Like (0)

Report

Re: Datable filter

Hi @Anonymous

we r not having separate option for filter
1 method u can use if conditions
2nd method u hav to work on excel as a database nd use query to execute it s more easy

Regards
Ahammad Riyaz
Community Power Pla... on 29 Jun 2021 at 06:21:16

Like (1)

Report

Re: Datable filter

if your data table is from database (even excel can be a database), then you can easily use SQL to filter data. Refer to below as examples:

https://powerusers.microsoft.com/t5/General-Power-Automate/Trying-to-use-Excel-as-Database/m-p/88040...

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Connection-String-for-Csv-file-csv-as-a-d...
drkeek 35 on 22 Jun 2021 at 00:59:21

Like (3)

Report

Re: Datable filter

@Rohith_Raju thank you for your solution but this is a serious deficiency compared to other RPA solutions.
Datatable manipulation really should be at top of the list for upcoming changes.
Rohith_Raju Microsoft Employee on 20 May 2021 at 09:41:32

Like (0)

Report

Re: Datable filter

Hello @Anonymous ,

I would recommend you to copy the values of the Data Table to an Excel, and perform filtering in Excel, using Surface Automation (Keyboard and Mouse Clicks).

This way your development will be much more easier, as Data Manipulation from an Output Data Table will be tedious and time consuming.
WorkingForFood 99 on 10 May 2021 at 18:00:15

Like (2)

Report

Re: Datable filter

Do you know if Microsoft has plans to make data table manipulation any friendlier? I haven't seen anything related on the road map, but I'd hope for cleaner solutions to data table issues.
fraenK 2,125 on 06 May 2021 at 08:40:01

Like (1)

Report

Re: Datable filter

Unfortunately, you'll need to loop through the data table and check each row to build a new data table, which would also be the easiest solution with PAD:
https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#advanced-data-types