Unanswered

HTML Table via email or cell values into email

(0) Share

Report

Posted on by TJ-13110204-0

Hi,

I am trying to get a flow that creates a new folder and spreadsheet each time a response in forms is submitted. I have managed to get it working so a new folder is created, named appropriately based on the input to the form and spreadsheet is created. Then I am updating certain values in the spreadsheet to Yes based on the questions - This is driving some effort calculations in the spreadsheet which are put into table 2.

I am hoping to get to a point where I can send an email with the values in the table 2 spreadsheet. - Have attempted to get the list rows and put the output into a HTML table which works but it adds the odata.etag and the iteminternalid into the email (screenshot of output attached) also table isn't formatting correctly.

Can anyone think of a way of removing odata.etag and itemiternalid from the email also formatting maybe via CSS? Alternatively the spreadsheet I am using is the same (just a new copy for each form) so I know which cells I need to pull into the email but can't seem to find a way of making it work (because it's a new copy of the same sheet each time created in a different folder driven by the input from the form).

Thanks in advance.

Categories:

General topics

All responses (7)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @tj15

To avoid other properties like internalitem id etc, use this approach

Select Columns dropdown as Custom and then specify the columns which you need in output html table as shown above. This will help to get remove the other non-required properties.

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
TJ-13110204-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nived,

Thanks for your reply, would this work with a dynamic file?

I currently have the file in the create HTML Table as body/value as it's dynamic so not sure how I would add the custom column?
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tj15

what you meant by dynamic file- is it reffered ti dynamic rows/dynamic columns ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
TJ-13110204-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nived,

So I can't select the file as it's created each time a form is submitted.

In your example you have selected the file value as it's a single file, I have the file being created via share point each time so have the body/value in the from option but this means can't select the column name.

Hope this make sense.
TJ-13110204-0 on at

Like
a
(0)

Report
Copy link

Link copied!

The other option I am thinking about is if I could set the specific cells values in the newly created spreadsheet as variables then add the content into the email. I only need to output about 6 cells into the email but struggling because I create the item earlier in the flow and want to use this flow for multiple projects. Every time they submit a form - Create Folder - Create Spreadsheet - Update rows on spreadsheet based on form items - Then get table 2 data (or the specific cells) and email that to the person who submitted the form.
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tj15

got it !

See Instead of selecting column name as dynamic content from List rows- you can write this expression as well- item()?['column name'] see below

This is to get tables from the file /excel file which flow have created.

Expression used-

first(outputs('Get_tables')?['body/value'])?['id']

Expression to get the table id

Assume - i have 4 columns- A,B,C and D in excel file, but i want A and B in my html table, so you can try this expression as well to get values instead of by selecting dynamic contents

to select /get values of A or B- used expression item()?['A'] or item()?['B'] - where item() represent each object under value array/dynamic content through which we are iterating.

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
TJ-13110204-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nived,

Thanks for all your help so far ...... Struggling a little and hopeful you can point out how I am going wrong

Get tables as per below setup and using the body/ID of the spreadsheet

List rows - Little confused here as I need it to always look at table 2 as that is where the data is held.
Have attempted to use the expression
Expression used-
first(outputs('Get_tables')?['body/value'])?['id'] but it didn't know to look at table 2.
Also just to confirm the file should be the body/ID of the spreadsheet that has been created by sharepoint (same as above?)
When creating the HTML file as per the below it just puts the heading into the email and doesn't add the actual value - Should I be adding the column name to the expression item()?['A'] - Replace A with column name from the excel file?