Changing column header

(0) Share

Report

Posted on by jarodriguezAU

Hi everybody.

After ready a bunch of articles and watching so many videos I am about to give up.

One of my process is send an email with an excel report, the report is create in Power BI and I want to use Power Automate to schedule that task. It is simple right, but when I am setting the component Create table (Img 2) I assigned the name of the columns I want but when the process run and my column header name is in [] (Img 4). I want to remove the []. SO I apply a select component (Img 3) with this script item()?['Individual ID'] but it doesn't work and now every time I test the process it gives me a null rows. Can you guys know what it is happening?

Img 1

Img 2

Img 3

Img 4

the result

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @jarodriguezAU ,

I don't understand. Do you mean you've set columns as Column1;Column2;Column3;... in Create table action but after testing the flow they converted to [Column1];[Column2];[Column3];...?

Best regards,

Was this reply helpful? Yes No
jarodriguezAU 2 on at

Like (0)

Report
Copy link

Link copied!

the "Select" should transform the name of the columns and it is not doing it.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @jarodriguezAU ,

The Select transformed the column names of Power BI output table. But the Excel table column names are setup in the Create table action.

Best regards,

Was this reply helpful? Yes No