Power Platform Community Forum Thread Details

Power Automate flow -create CSV table - custom columns - doesn't recognize the column name

3 seconds ago

I have a flow that get the data from "Run a query against a dataset". Then I create a CSV table. Then Export it to google drive. In Create CSV table, if I choose Columns as Automatic, in the csv file generated in google drive, it contains all the columns but columns are not in the order from "Run a query against a dataset". So in Create CSV table, I changed Columns to Custom. Then I starts creating Header and Value for all the columns in the order. All the other columns works fine except one column [4_Phase_No] that it can not recognized it.

The error code is something like this

The execution of template action Create_CSV_table failed. The column values could not be evaluated: 'The template language expression 'item()['[4_Phase_No]']' cannot be evaluated because property '[4_Phase_No]' doesn't exist, available properties are '[1_IT_Budget_Year], [2_Product], [3_Product_Name], [5_Phase_Name], [6_Phase_Type], [8_Client_Group], [9_Employee_Name], [10_Phase_Type_Code], [11_Nb_Days], [12_Amount]'. Please see https://aka.ms/logicexpressions for usage details.'.

But the column [4_Phase_No] is in the INPUTS of Create CSV table