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:

Business Process Flows

All responses (3)

Answers (0)

v-jefferni on at

Like (0)

Report

Re: Changing column header

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,
jarodriguezAU 2 on at

Like (0)

Report

Re: Changing column header

the "Select" should transform the name of the columns and it is not doing it.
v-jefferni on at

Like (0)

Report

Re: Changing column header

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,