Skip to main content

Notifications

Community site session details

Community site session details

Session Id : elLFrvxnmrQoKfFcGo87Jc
Power Automate - Building Flows
Answered

Create CSV table Output empty

Like (0) ShareShare
ReportReport
Posted on 21 Sep 2022 15:04:10 by 44

Hello guys

 

I'm building a CSV table from an Azure query, this is the flow:

dev85_0-1663771163050.png

when I tested the flow, I'm getting this results:

dev85_1-1663771950045.png

So, the Create CSV table it is reading fine the Query from devops(the input is right), however as you can see the Output just shows empty values.

I'm loading the Create CSV action like this:

dev85_2-1663772138099.png

One curious thing, at first in the create sharepoint file, I leave the file name with no .csv extension (I forgot) so when I run the flow it created a file with no extension, however when I renamed and add the .csv it worked and all the data from the query was in there perfectly, but when I add the .csv in the file name field in the Create File step, it just give me an empty table with just the column headers.

 

Any help would be appreciated.

 

  • czybach Profile Picture
    2 on 13 Mar 2023 at 22:25:50
    Re: Create CSV table Output empty

    Is there a solution for this that persists other than just having to rewrite all of the references every time you save the flow? I'm having the same issue, that every time I open the flow to edit it, the references revert from "." to "']?['" , which means every single time I have to service the flow I have to rewrite all of the dynamic content. How do I get it to not revert to the incorrect format?

  • dev85 Profile Picture
    44 on 21 Sep 2022 at 16:45:46
    Re: Create CSV table Output empty

    Hi @Expiscornovus 

     

    Thank you so much. I didn't know how to correct the missing dot error and I just write the corrected expression in the column values and it worked perfectly. 

  • Verified answer
    Expiscornovus Profile Picture
    31,652 Most Valuable Professional on 21 Sep 2022 at 16:02:15
    Re: Create CSV table Output empty

    Hi @dev85,

     

    Seems I can reproduce this issue. It looks like it turns the dot in the name of the field into two separate fields.

     

    In my CSV table action I was using the following expression for WorkItemType:

     

    item()?['System.WorkItemType']

     

     

    When I reopen the flow in edit mode that got changed to:

     

    item()?['System']?['WorkItemType']

     

     

    That property does not exist and therefore it cannot find the values of it.

     

    workingflowgotcorrupt.png

     

    Here is an animation of the same behaviour.

     

    DotSeparateFields.gif

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 > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 51

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 39 Super User 2025 Season 1

#3
CU30040420-0 Profile Picture

CU30040420-0 23

Overall leaderboard
Loading started