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

(0) Share

Report

Posted on by 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:

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).
Also, the date time values are showing up as ISO8601 date time values.

Many thanks in advance for the assistance!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,480 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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')

Was this reply helpful? Yes No
lzh1991 12 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Expiscornovus 33,480 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No