Issues with a specific Excel column during import

(0) Share

Report

Posted on by greddin

112

Hi all, I have a flow that is listing the rows in an Excel file then importing them into a SQL table.

The issue I'm having is the values are always empty for this specific Excel column.

Excel column

The SQL action allows me to select the field.

Closer view of the field

When the flow runs it populates all columns except this one. I'm sure the weird naming of the column is causing the issue. I'm not easily able to have the user rename this column.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report
Re: Issues with a specific Excel column during import

Hi @greddin ,

It seems that the '/' special character cannot recognized.

Please try to rename the column name in flow.

json(replace( string(outputs('List_rows_present_in_a_table')?['body/value']),'HEAT _x0023_\n/ P _x0023_','tempColumn'))

Best Regards,

Wearsky

Was this reply helpful? Yes No
greddin 112 on at

Like (0)

Report

Re: Issues with a specific Excel column during import

Thank you Wearsky!

Was this reply helpful? Yes No