Fail to set a new DataTable using the current item FOR EACH got

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi community,

Would you please help me with below question? Thanks in advance.

There is the datatable "TestExcelData" which is from reading from my excel worksheet.

And then I created new blank datable with static header like below.

Then I will use For-each action to loop the "TestExcelData" the first datatable and use condition to identify if the current item is target or not.

What i want to do is to add this current item into my new blank table just created If the result is True. Can I use the Set variable to do this? Please give me a hand on this. Thanks!

Categories:

Power Automate Desktop

All responses (5)

Answers (1)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Here is the website for the syntax:

https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types

here is a screenshot excerpt:

following the protocol here, you should be able to add a row.

it should be like this:

If you are still having trouble, so two things for me. 1) screenshot the inside of your last Set variable, so I can see where the % marks are, and
2) Set clipboard text exactly how you set variable, so we can see what the output is. It’s possible that we are just missing a [] or {}.

good luck!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi MichaelAnnis
Hope you are doing well and thanks for your reply!

Yes, Actually I have learned that way you just shared to add the value into datatable. But the value must be hard code like ['Product3', '30 USD'].

And what I want to do actually is how to use the current item to add into a datatable instead of using the static value.

I have tried below to do, but still failed.. Any idea?
Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Yeah…do this:

%DataTable + CurrentItem2%
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It works!
Really hope that Microsoft should add this session into learning doc.
Thanks MichaelAnnis!
MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

It’s kind of there. It is just tricky and very subtle.

notice in my second screenshot in my first post…

it is not %Products% + …

it is %Products + (then new datarow as text) %

so, in your case, CurrentItem replaces new datarow, and you are able to add the datarow to the existing table.

glad I could help.