Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Js1yW1BbQzLFx/SEWRLplS
Power Apps - Building Power Apps
Answered

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

Like (0) ShareShare
ReportReport
Posted on 23 Mar 2023 17:34:59 by 5

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

LiZhu_0-1679592705926.png

I couldn't figure it out why. Hope someone  can help. 

Thanks!
Li

  • HamzaAli Profile Picture
    6 on 14 Sep 2023 at 05:35:41
    Re: Power Automate flow -create CSV table - custom columns - doesn't recognize the column name

    Hi,

     

    I'm stuck with same query, can you please share the idea how did you create column headers and values?

  • LiZhu Profile Picture
    5 on 23 Mar 2023 at 19:33:47
    Re: Power Automate flow -create CSV table - custom columns - doesn't recognize the column name

    That works 🙂

    The ? makes a difference!

     

    Thanks!

     

    Li

  • Verified answer
    CU-18081211-6 Profile Picture
    9,266 Super User 2025 Season 1 on 23 Mar 2023 at 18:57:41
    Re: Power Automate flow -create CSV table - custom columns - doesn't recognize the column name

    @LiZhu ,

    Can you try 

     

    item()?['[4_Phase_No]']

     

    and check the outputs to see the results ?

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,786 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard
Loading started