Answered

Issue with Creating HTML Table

(0) Share

Report

Posted on by 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

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

mansari1 7 on at

Like (0)

Report
Copy link

Link copied!

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??

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
mansari1 7 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Rahber 1,935 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No