Issue with Creating HTML Table

[mansari1]

Hi - I have an online excel sheet and I am trying to trigger a recurring flow. Basically, the excel sheet has a date column and I am filtering the entries belonging to the current day and sending the filtered results via email notification. My flow looks like this.

It does the filtering job properly but there is one problem which I am unable to resolve. The email I receive looks like this:

@odata.etag	ItemInternalId	Name	Note	DateISO
	11ea9607-a596-4841-be8b-c086688d194d	James	Just a couple of hours	07-15-2020
	d4ee0ecc-c8f0-4833-ac28-738cf7a43c9b	Mohammad Zaki	-	07-15-2020

How can I get rid of @odata.etag and ItemInternalId in the sent email?

I tried to use Custom Column under advanced options but it forced the Create HTML connector into a loop and resulting output in my email was also messed up.

So my question is, how can I get rid of first two columns in my email??

Thanks,

Zaki

[Rahber]

on your create the html table select show advanced options and then select custom.

You can now give the names of the columns and the corresponding values from your filter array function .

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,

Rahber

[mansari1]

Hi Rahber - I did this but as I mentioned in my original post, as soon as I enter something in Values column the Create HTML connectors gets embedded in the loop by itself. See image below

See this image https://ibb.co/4R16Vd0 (for some reason editor is not letting me attach images)

The flow still works but the response looks like this. TO me it seems like since there are two entries in the original table the loop is printing it twice and returning two tables.

["

Date	Name
07-15-2020	James
07-15-2020	James

","

Date	Name
07-15-2020	Mohammad Zaki
07-15-2020	Mohammad Zaki

"]

[v-bacao-msft · Accepted solution]

Hi @mansari1 ,

You should use the data output from the Filter array to configure Create HTML table action instead of using the dynamic content output from List rows present in a table action.

You need to use expression to refer to the field value, item()['columnName'].  Like:

Please obtain the name of the field in the body of List rows present in a table action and configure it in the expression.

Best Regards,

[mansari1]

Thank you so much!! It works. Just a follow up question so I know I understand it properly, array from the previous step is always stored in item() variable & it could be sliced using usual json way??