Power Platform Community Forum Thread Details

I want use filter Array Data to build HTML table, if I use Automate column, is OK, but I want only select some column, it will add each item， and table not use filter data.

Categories:

Building flows

Hi @Andrewlu81 ,

It's happening because you are passing a property from your Excel action as parameter for 'Create HTML Table'. As your Excel action is a List containing several objects, each one with properties to identify the columns, this is the expected behavior. For example, this table:

Generates this output in "List rows in Excel table" action:

In yellow you have the "value" element, which is a list of objects, representing each row from the table. In pink you have the start/finish of each object (they are delimited for "{}"). In blue you have the properties related to the columns (I'm assuming that you are trying to access something from the columns).

To access the value from one of these rows/columns, you can use this expression: outputs('List_rows_present_in_a_table')?['body/value'][0]['B']

In blue you have the output from you Excel file: in your flow, it may be different from mine. In red, you have the index of the row that you want to access. In my case, I'm accessing the first row of the table (the count starts in zero). Finally, in green I'm specifying the column from where I want to extract the data. In my case, my column name is 'B' (it is not the column address in Excel file, this is just a name that I gave in my table header to the column).

I'm not sure if your goal is to access a specific value from your Excel table (instructions above), or if you need the name of the column. If this last one is the case, let me know!