Issues with a specific Excel column during import

[greddin]

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!

[v-xiaochen-msft · Accepted solution]

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

[greddin]

Thank you Wearsky!