Create datatable row variable, with variables as values

(1) Share

Report

Posted on by roccolord

Hi I'm trying to create an excel row, which I want to insert into an excel row, row by row.

Created a datatable variable, with variables as input. But I only get %value1% %value2% in the excel row, and not the actual value of the variable as i created in the row. Guess I have the wrong syntax, or escaping?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

Can you get this into text? Such as:
Variable1, Variable2, Variable3

Because then you could paste it into an excel row and use UI elements to Data, Text to columns, comma delimited.

Was this reply helpful? Yes No
roccolord 63 on at

Like (1)

Report
Copy link

Link copied!

Thanks, but I'm not following what you are suggesting, I'm afraid.

Was this reply helpful? Yes No
roccolord 63 on at

Like (3)

Report
Copy link

Link copied!
Correct syntax for the above is:
%{[MyName, PNO, MyNbrVisits, MyDouble, SavedMyEmployees.Count, Gender] }%
So just drop the % from the variables and their values will be filled in each column in the excel.

Was this reply helpful? Yes No
kimmer 4 on at

Like (1)

Report
Copy link

Link copied!

THANK YOU! 🙂

Was this reply helpful? Yes No
Suggested answer

Ukiman1014 on at

Like (1)

Report
Copy link

Link copied!

When I tried using these examples they worked BUT they just kept adding values to the same row over and over again (basically overwriting the same row). Here is the syntax to keep adding new rows, with variables as the values. I assume if you wanted a static value somewhere in there, you'd just enclose it in single quotes (').

I used this syntax to first create the data table, naming each column.
Set variable
%{ ^['Column Name 1', 'Column Name 2'] }%

Was this reply helpful? Yes No