Answered

Stuck creating an HTML Table after Append to array variable

(0) Share

Report

Posted on by Alejotecelec

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 )

But I get this message from Create HTML Table:

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

Any help really appreciated !!!

The full flow :

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Alejotecelec

Looking the screenshot why you have two Curley brackets?

Ideally it should be

[

{

"ID":333,

"Name":"David"

},

{

"ID":555,

"Name":"Smith"

},

{

"ID":892,

"Name":"Albert"

}

]

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Alejotecelec 8 on at

Like (1)

Report

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

Was this reply helpful? Yes No