Answered

Create custom column names for HTML table

(1) Share

Report

Posted on by JC-24071247-0

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?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @JoeCrozier

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

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

Thanks

Was this reply helpful? Yes No
JC-24071247-0 50 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No