We Finally Have DataTable Actions in Power Automate Desktop

In this Power Automate Desktop (PAD) video, I try out the new DataTable (data table) actions that were recently added to Power Automate Desktop. Previously, it was impossible or extremely annoying to change data in a DataTable within PAD. I personally think these actions should have been added a long time ago, but it’s better late than never. =)
---------------------------------------------------------------------------------------------------------
Power Automate Desktop Version 2.23.00184.22217
Windows 10 Pro
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
00:00 Introduction
03:06 Try action - Create new data table
09:03 Try action - Insert row into data table
10:34 Try action - Find or replace in data table (using Find)
14:00 Try action - Update data table item
17:58 Try action - Find or replace in data table (using Replace)
20:13 Try action - Delete row from data table
21:53 Build a Use Case for Practice
01:35:24 Conclusion

[dalotos]

Really concise and fully covered everything I've been painstakingly looking for for weeks. Thanks mate!!

[csabatoth]

Really enjoyed following your thought process and that you got lost sometimes.

[DigitalizacionValue]

I'm just starting with Power Automate Desktop so I sometimes encounter a number of difficulties that I'm sure you can easily solve for me. So, the problem is related to Excel because, I've got a table with 20, 000 rows and growing and I need to delete a number of rows that contain a certain value in column X. Then, if I make a loop with the ExcelData I can be, approximately, 3 hours waiting, so it is not effective at all...

[Katleenfarine]

51:20 It's great that you show us what type of error we can do... but, it would be great of there was a -> skip to the real method, haha, so we don't get mixed.

[MrMully]

Hello, thanks for sharing, I have a question in PAD, Is it feasible to format data in a DataTable prior to pasting it into Excel? The purpose of this formatting is to prevent large numbers from being converted to exponents.

[Volkanizma]

I cannot believe there is STILL no filter action for data tables

[AbdulSamadKhan-jjeo]

Can you please also make video for how to sort datatable . i have google could not find any thing sorting look like PAD not supporting Sort in datatable

[kng]

Is it possible to use two "Read from CSV file" actions to APPEND data into the one Data Table or do you need to Read them both into separate Data Tables and then combine them like you did?

[karthickskd]

Thank you for sharing. I 'have been following your videos and all are awesome especially X-path which is helping out a lot for automating dynamic web applications. I have a doubt in BP tool. How to know that the grid or table is loaded properly in a page via ajax call ? I'm using table element then parent document loaded in wait stage but it doesn't help. Any suggestions?

[edtignor]

Do you have any videos on passing data table variables from PA to PAD?

[dexterlee]

Hi thanks for the great sharing wondering how do I delete column after create datatable?thanks

[edtignor]

Can you do an update video on CSS selectors? They are still screwing me up. I’ve been stuck with trying to move mouse and click. Obviously that’s not ideal.

[MsRiko]

do you have any idea how to convert data list to data table or we can say convert column to row using power automate

[niranjanar]

Is there any way to sort data table based on a particular column?

[RyanPuffer-rn]

"This is the alphabet by the way."