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
I couldn't figure it out why. Hope someone can help.
Thanks!
Li
