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

[lzh1991]

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.

Many thanks in advance for the assistance!

[Expiscornovus]

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')

[lzh1991]

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?

[v-yujincui-msft]

Hi @lzh1991 ,

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

1. Here is my SharePoint list. 

2. Here is my Flow. 

Result Screenshot: 

Best Regards, 
Charlie Choi 

[Expiscornovus]

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.