Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Sharepoint List to CSV file but data is in the same column

(0) ShareShare
ReportReport
Posted on by 12

Hi all, 

I'm really new to Power Automate so would appreciate your advice on this: 

 

Trying to export data from my Sharepoint List to a .csv file (example in the screenshot below), but I have two issues:

 

  1. The data is the created csv file is not showing up in separate columns (i.e. they are all lumped together in the same cell).
  2. Also, the date time values are showing up as ISO8601 date time values.

 

lzh1991_0-1661496417013.png

 

Many thanks in advance for the assistance!

  • Expiscornovus Profile Picture
    Expiscornovus 31,139 on at
    Re: Sharepoint List to CSV file but data is in the same column

    Hi @lzh1991,

     

    Thanks for sharing the raw inputs of the Create CSV table aciton.

     

    Apologies if it is was not clear. But I was looking for a screenshot of the whole flow setup.

    So, I can see what other actions you are using besides the Create CSV table. This might give us a clue why your issue is happening.

  • Re: Sharepoint List to CSV file but data is in the same column

    Hi @lzh1991 ,

     

    I have made a simple test but it seems works fine on my side. 

     

    1. Here is my SharePoint list. 

    vyujincuimsft_0-1661841120046.png

    2. Here is my Flow. 

    vyujincuimsft_4-1661841345332.png

    vyujincuimsft_5-1661841371457.png

    Result Screenshot: 

    vyujincuimsft_3-1661841120051.png

     

     

     

     

    Best Regards, 
    Charlie Choi 

  • lzh1991 Profile Picture
    lzh1991 12 on at
    Re: Sharepoint List to CSV file but data is in the same column

    Hi @Expiscornovus ,

     

    Thanks for your reply. 

     

    So here's the raw inputs for the 'Create CSV table step'

     

    {
        "from": [
            {
                "@odata.etag""\"1\"",
                "ItemInternalId""3",
                "ID"3,
                "Title""123456",
                "PatientType": {
                    "@odata.type""#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                    "Id"-1,
                    "Value""Corporate"
                },
                "PatientType#Id"-1,
                "VisitStart""2022-08-26T05:56:00Z",
                "VisitEnd""2022-08-26T05:56:00Z",
                "BloodTestStart""2022-08-26T05:56:00Z",
                "BloodTestEnd""2022-08-26T05:56:00Z",
                "ECGStart""2022-08-26T05:56:00Z",
                "ECGEnd""2022-08-26T05:56:00Z",
                "TreadmillStart""2022-08-26T05:56:00Z",
                "TreadmillEnd""2022-08-26T05:56:00Z",
                "DrStart""2022-08-26T05:56:00Z",
                "DrEnd""2022-08-26T05:56:00Z",
                "BodyAnalysisStart""2022-08-26T05:56:00Z",
                "BodyAnalysisEnd""2022-08-26T05:56:00Z",
                "AudiometryStart""2022-08-26T05:56:00Z",
                "AudiometryEnd""2022-08-26T05:56:00Z",
                "OptometryStart""2022-08-26T05:56:00Z",
                "OptometryEnd""2022-08-26T05:56:00Z",
                "RadiologyStart""2022-08-26T05:56:00Z",
                "RadiologyEnd""2022-08-26T05:56:00Z",
                "Status""Discharged",
         
     
    Somehow the raw outputs get transformed into a single line of data as below:
     
    Title,VisitStart,VisitEnd
    123456,2022-08-26T05:56:00Z,2022-08-26T05:56:00Z2022-08-26
     
    How can I circumvent this issue?
  • Expiscornovus Profile Picture
    Expiscornovus 31,139 on at
    Re: Sharepoint List to CSV file but data is in the same column

    Hi @lzh1991,

     

    The header value mapping looks alright. Can you post a screenshot of the rest of your flow? This will help us troubleshoot issue 1.

     

    For the date time values you could use an expression with a formatdatetime function in your Create CSV table action.

    formatDateTime('<timestamp>', '<format>'?, '<locale>'?)

     

    Try for example this instead of the Visit End Value. You can copy paste that into the expression editor.

    formatdatetime(item()?['VisitEnd'], 'yyyy-MM-dd')

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard