Creating HTML Table from Filtered Array

Frequent Contributor

Hello, 

 

Hoping this is easy. I get some SharePoint items using "Get Items", I then Filter that array based upon an ID in the last using "Filter Array." All good up to there. I then want to "Create HTML Table" based upon the filtered Array, but I cannot figure out what values I should be putting in the Custom Columns. If i use the content from "Get Items" it creates a loop which I don't want.

 

Thanks

3 Replies

Hi Joe,

 

I realize this is an old and unanswered post - but did you get this issue figured out?  I have the same use-case and I am kind of stuck.

 

 

@Joe Fedorowicz I'm having the same issue; did you ever resolve this? When I add values from the Get items phase, I get an Apply to each added to my Create HTML table step which I don't want. 

@cschneider1820 

 

I did finally get mine to work.  I created a quick example ( mine wasn't as easily shareable ).

 

Populate array variable.  In this example, just insert 3 "rows":

coyote_ptm_0-1614044229265.png

Filter array:

coyote_ptm_1-1614044292337.png

The "is equal to" in advanced is: "@equals(item()?['DocumentID'], 10)"

 

Send output from "Filter Array" to "Create HTML Table"

coyote_ptm_2-1614044380877.png

 

The "From Body" = '@{body('Filter_array')}'

 

The "Value" = '

item()?['DocumentID']'
 
Here's the output of run for create html table.
coyote_ptm_3-1614044547108.png

 

 

Hope this helps.