web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Update datatable

Power Automate

Answered

Update datatable

(0) Share

Report

Report

Posted on by Cable998

16

I have an excel Datatable, which I can update as such:

%ExcelTableData[2]['Records']%

Which updates the column records

I can read each row as such:

I can write the DataTable to excel by

If I want to read a datarow, process it and then update the data table, I am having problems

Updating S1_CurrentItem does not update the data table.

Is there any way I can dynamically update the data table?

Categories:

Power Automate Desktop

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Cable998

Unfortunately doesn't look like there is an option to do that right now.

One way is, as you loop through the data table, maintain row and column counters, and use these row/column variables in the "Write to Excel Worksheet". This will directly write the new value in the Excel sheet.

after the above message box

Column is fixed as 1 in this example and only the row is incremented.

-------------------------------------------
Help fellow beings find relevant posts.
Upvote to a supporting response.
Mark as solution to an answer.
Verified answer

Cable998 16 on at

Like
a
(3)

Report
Copy link

Link copied!

Hi,

I have worked out how to do it, I presumed it was the syntax was like printf variables and the % signs were used to specify variables.
Looping through each row, allows me to update the datatable, and then bulk write it back to Excel, thusly:
VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

@Cable998 , glad you figured it out 🙂. When I tried the same it was giving me the same issues as yours (datatable was not updating the values to Excel).
subhasmalik 6 on at

Like
a
(0)

Report
Copy link

Link copied!

You are the savior!
Respect 😎
Sanchos_Bro 5 on at

Like
a
(0)

Report
Copy link

Link copied!

May be a new feature since this post:
Find or replace in data table

Join the conversation