Skip to main content

Notifications

Power Automate - Power Automate Desktop
Unanswered

Create datatable row variable, with variables as values

Posted on by 63

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?

 

wrr.png

  • Suggested answer
    Ukiman1014 Profile Picture
    Ukiman1014 223 on at
    Create datatable row variable, with variables as values
    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'] }%
  • kimmer Profile Picture
    kimmer 4 on at
    Re: Create datatable row variable, with variables as values

    THANK YOU! 🙂

  • roccolord Profile Picture
    roccolord 63 on at
    Re: Create datatable row variable, with variables as values

    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.

  • roccolord Profile Picture
    roccolord 63 on at
    Re: Create datatable row variable, with variables as values

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

  • MichaelAnnis Profile Picture
    MichaelAnnis 5,723 on at
    Re: Create datatable row variable, with variables as values

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,733

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard