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
Hi,
I'm stuck with same query, can you please share the idea how did you create column headers and values?
That works 🙂
The ? makes a difference!
Thanks!
Li
WarrenBelz
146,786
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional