Forum Discussion

Joe Fedorowicz's avatar
Joe Fedorowicz
Iron Contributor
Nov 09, 2017

Creating HTML Table from Filtered Array

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

Microsoft Flow
  • cschneider1820's avatar
    cschneider1820
    Copper Contributor
    Feb 12, 2021

    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. 

    • coyote_ptm's avatar
      coyote_ptm
      Copper Contributor
      Feb 23, 2021

      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":

      Filter array:

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

       

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

       

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

       

      The "Value" = '

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

       

       

      Hope this helps.

  • coyote_ptm's avatar
    coyote_ptm
    Copper Contributor
    Oct 09, 2020

    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.

     

     

Resources