Answered

Changing Column Names in HTML Table

(2) Share

Report

Posted on by smodkins

Hi there,

I have this flow which is manually triggered from an excel file which contains a list of rows and in those rows is the reponsible individuals email address. The flow pulls all of the email addresses and creates a unique list and then sends one single email with a table of the information to each unique email address. The flow is working as expected but I need to change the column headers and it appears you can't have them with a space in the Create HTML table action.

I've read you can do this via a select query but I do not know where you would insert this into the flow and I've read some posts say a select query is not compatable with the List rows present in a table action but those posts were from 2020 so perhaps that has changed since.

Thanks in advance

All responses (5)

Answers (1)

smodkins 85 on at

Like (1)

Report
Re: Changing Column Names in HTML Table

A bit of googling shows for a column name with an apostrophe to use two single quotes which worked perfectly (just in case it's helpful to anyone else)

item()?['Worker''s Manager']
smodkins 85 on at

Like (1)

Report

Re: Changing Column Names in HTML Table

Hi Michael,

I've spent an hour or two trying everything to get it to work with little success. I deleted the apply to each and completely started from scratch in that section and it's now working as expected! It was probably user error 😂

Once last question if you would be so kind? One of the columns on the source data is called Worker's Manager and the item()?['Worker's Manager'] doesn't like the additional apostrophe at all. Is there a way around this?

The source report isn't mine to amend unfortunately

Thanks again
Verified answer

Michael E. Gernaey 43,422 Super User 2025 Season 1 on at

Like (1)

Report

Re: Changing Column Names in HTML Table

Hi @smodkins

THe Filter array should be and then you use

item()?['ColumnNameFromArray']

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
smodkins 85 on at

Like (1)

Report

Re: Changing Column Names in HTML Table

No sorry I meant the flow is manually triggered:

That's what I thought it would be but I cannot get it to work

What action should be in the from?
Michael E. Gernaey 43,422 Super User 2025 Season 1 on at

Like (1)

Report

Re: Changing Column Names in HTML Table

Hi @smodkins

Hold up, you said its manually triggered from an Excel. There are no Manual triggers that act like that. Do you mean it automatically striggers from an Automated Trigger that looks for file changes in Excel or something?

@smodkins The select, it goes right after your Filter Array <== is the answer

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey