Skip to main content
Community site session details

Community site session details

Session Id : NeeUXhQZIbuF5uE5jiIgcR
Power Automate - Using Flows
Answered

Stuck creating an HTML Table after Append to array variable

Like (0) ShareShare
ReportReport
Posted on 28 Nov 2023 21:24:47 by 8

Hi, 

 

I'm stuck here! Basically I have to tables "List Constituents" and "Get a constituent last gift" I'm initializing variable because I need data from "Get a constituent last gift" that is not available in "List Constituents", all works and the final result Append to array variable has the information I need. The problem comes when I try to convert that result in a HTML Table ( I wanna send an email that contains the info in the Append to array variable result ) 

 

This is what I got in the Append to array variable ( all information I need ) 

Alejotecelec_0-1701206246750.png

But I get this message from Create HTML Table:

Alejotecelec_1-1701206319973.png

Alejotecelec_2-1701206413722.png

I have tried defining the columns but it doesn't work either the field gray out immediately:  

 

Alejotecelec_3-1701206491744.png

Any help really appreciated !!! 

The full flow :

 

Alejotecelec_0-1701206780935.png

 

  • Alejotecelec Profile Picture
    8 on 28 Nov 2023 at 23:37:57
    Re: Stuck creating an HTML Table after Append to array variable

    Thanks @abm . That was the problem !! Now is solved !

  • Verified answer
    abm abm Profile Picture
    32,506 Most Valuable Professional on 28 Nov 2023 at 23:07:39
    Re: Stuck creating an HTML Table after Append to array variable

    Try the below

     

    Add a compose above the Append to array. Inside the compose map the values like below

     

    {

      "ID":555,

      "Name":"Smith"

    }

     

    Then append the array using the compose action step. Finally use the append array variable for the HTML action step.

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 28 Nov 2023 at 23:06:07
    Re: Stuck creating an HTML Table after Append to array variable

    Hi @Alejotecelec 

     

    Looking the screenshot why you have two Curley brackets? 

     

    image.png

     

    Ideally it should be

     

    [

    {

      "ID":333,

      "Name":"David"

    },

    {

      "ID":555,

      "Name":"Smith"

    },

    {

      "ID":892,

      "Name":"Albert"

    }

    ]

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete