Hi all, I am trying to extract data from an excel file and display it in an email where there is a specific value that has been met. However, it has been giving me this extra 2 columns while displaying the html table. Any headway to this?
MY FLOW:
Hi,
when I do this I automatically get apply to each. and I can't use that dynamic content
Ok Thanks
key = the desired name of the column in the resulted array of objects,
value = item()?[‘name_the_column_from_Excel’]
What is the key and value for the map section?
Use a select action after the filter array action, and in it create the output for HTML table, column name - value.
From -> body('Filter_array');
Map - > Key - Value.
Also, Can you take in consideration to use ODATA filter inside "List rows present in a table" instead of bringing all values to flow and filter it locally ? (this is applied only if the filter condition is not to complex, as the Excel connector doesn't support many operations).
Of course, that in this case the From from the new select action will be
(use the Add dynamic content ->expressions):
body('List rows present in a table')['value']
Hope it helps !