How to update a datatable value by using for each function

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Community,

I am new to PAD.. Please help me with below datatable question. Thanks a lot!!

There is a datatable which was generated from website but some fields are blank.

What I want to is to use for-each function to loop the datatable and then use a current item field to another current item field (same row).

I have tried "CurrentItem[2]" to set "CurrentItem[1]" which is ok for current item but can not update the related value of datatable I am looping.

Datatable:

And I also tried to use this way to update but it only can update the related row I set..So I want to use the variable to locate next row I want to update but seems there is no way to use.. Any ideas?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Rkv_ 166 on at

Like (1)

Report
Copy link

Link copied!

As of now there is no way to update the datatable variable directly.
You can try writing the datatable to excel a blank excel sheet. then you can use SQL quires on the excel to modify the data, Then you can read the modified data from excel sheet using Read from Excel action and that will create a new datatable.
Fyi,
https://docs.microsoft.com/en-us/power-automate/desktop-flows/how-to/sql-queries-excel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sad to know that PAD can not do this directly which is such kind of basic function..
Anyway, thanks for your suggestion!!

Was this reply helpful? Yes No
Verified answer

Rkv_ 166 on at

Like (2)

Report
Copy link

Link copied!

I can give you one more suggestion here, instead of doing SQL queries on Excel,
There is one simple way for your requirement. Please don't use for each loop, as you need to update each row and you will be looping through the same row.

So try using the Loop action, loop from 0 to %Datatable.RowCount-1% and increment by 1
inside the loop you can simple set variable.

I hope this is the solution you are looking for.
Please mark it answered if you are satisfied.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous
Could you take a look and see at the solution in this post and if it is in line with what you are looking for.
https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Update-datatable/m-p/1286967/highlight/true#M7139

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks VJR also!!

Was this reply helpful? Yes No