Create custom column names for HTML table

[JoeCrozier]

I have this flow:  

For the purposes of this question, I think only the red steps really matter.  The Blue steps just create a pdf that is also attached.

Well the overall goal of what I am doing is:  querying a Power BI dataset online, and including the results of that query as a table in an email.  And it mostly works, here is a screenshot of an example email:

My problem is, I dont want column headers that are like "rv_protocol_details_mgmt_prim_spon[PROTOCOL_NO]"

Instead I just want a simple "Protocol No."  How do I change that?   I'd thought it might be on the "Create HTML Table" step by selecting advanced options and selecting custom columns, but I dont get anything I can 'fill in' when I do that:

I.e. no columns pop up.

Any ideas?

[abm · Accepted solution]

Hi @JoeCrozier 

Under the Header type whatever header you want. Then under the value use the expression

item()?['Your column name here']

Thanks

[JoeCrozier]

That worked great thank you!

I accepted it as solution but I'm wondering if I could ask two follow-up questions:
-Is there a way to put a space in there?  "Protocol Status"?  It didn't seem to allow me, I also tried quotation marks around it to no avail.

-How did you learn that?  Is it a specific programming language?

[abm]

Hi @JoeCrozier 

Thanks for accepting the solution.

So thats the limitation of that. You can't add spaces in between but you can declare a compose action for that heading with spaces and map under that. Don't ask me why and that's the way it is. 🤣 See below please:

The other question you asked about specific programming language? This is called expressions? This is used for manipulating your string or numeric values / a bunch of functions.

Have a look at this

Introduction to expressions in Power Automate - Training | Microsoft Learn

Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Thanks