cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Datable filter

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. 

7 REPLIES 7
fraenK
Memorable Member
Memorable Member

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-type...

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.

Rohith_Raju
Microsoft
Microsoft

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.

drkeek
Advocate I
Advocate I

@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. 

timwang
Frequent Visitor

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...

 

Ahammad_Riyaz
Super User
Super User

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

@timwangthank you. 

Feels like added complexity to me but certainly looks like an option.  

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,336)