Unanswered

Power Automate Extract SharePoint List items to Excel using HTTP

(0) Share

Report

Posted on by CU21110735-0

Hi Members,

I have a requirement in Power Automate, that I need to export more than 50,000 or 100000 data from SharePoint list to Excel.

So for that, I started creating a flow, as per below mentioned steps:

Manually Trigger a flow
Send an HTTP request to SharePoint
1. uri = _api/web/lists/getbytitle('BO')/items
Parse JSON
1. Content: body(Send_an_http_request_to_SharePoint)
2. Schema:

{
    "type": "object",
    "properties": {
        "d": {
            "type": "object",
            "properties": {
                "results": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "Title": {
                                "type": "string"
                            },
                            "field_1": {
                                "type": "string"
                            },
                            "field_2": {
                                "type": "integer"
                            },
                            "field_3": {
                                "type": "string"
                            },
                            "field_4": {
                                "type": "string"
                            },
                            "field_5": {
                                "type": "integer"
                            },
                            "field_6": {
                                "type": "string"
                            },
                            "field_7": {
                                "type": "string"
                            },
                            "field_8": {
                                "type": "string"
                            },
                            "Modified": {
                                "type": "string"
                            },
                            "ID": {
                                "type": "integer"
                            },
                            "Created": {
                                "type": "string"
                            },
                            "AuthorId": {
                                "type": "integer"
                            },
                            "EditorId": {
                                "type": "integer"
                            },
                            "OData__UIVersionString": {
                                "type": "string"
                            },
                            "Attachments": {
                                "type": "boolean"
                            },
                            "GUID": {
                                "type": "string"
                            }
                        }
                    }
                }
            }
        }
    }
}

4. Create CSV Table: Result = body('parse_json')?['d']?['results']

But I am facing an error as: "The error indicates that the 'from' property in the 'Create CSV table' action is receiving a value of type 'Null', which means it is not getting the expected array of items. This is likely caused by the previous action, where the 'results' property from the parsed JSON is not being populated correctly. To resolve this, you should check if the 'body' of the HTTP request to SharePoint is returning the expected data structure, particularly if the 'd' and 'results' properties are present and contain an array."

Please help me out.

Thanks in advance!

Categories:

Building flows

export_error.jpg

I have the same question (0)

All responses (3)

Answers (0)

Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Since I can only see the action names and not the outputs, you should check whether the output from the Parse JSON action is not null. To do this, you can insert a Compose action to inspect the data and verify that the expression you used in the Create CSV action is returning the expected results.
By using the Compose action, you can confirm if the values you’re working with are correct before passing them into the Create CSV action. This will help you ensure that the expression is working as expected.

If I have answered your question, please mark it as the Answered. If you like my response, please give it a Like.

Regards,
Srini

Was this reply helpful? Yes No
CU21110735-0 2 on at

Like (0)

Report

When I use the compose action, we can see the fields are extracting. But still in the create csv table facing an error. Please help me out with the flow, how can I achieve it to extract more than 10,000 or 100000 data.

Was this reply helpful? Yes No
Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Can you share the output's of those actions like Send HTTP request to Sharepoint and Parse Json?

Also, show what you are passing in create csv table as well, you can hide any sensitive data

If I have answered your question, please mark it as the Answered. If you like my response, please give it a Like.

Regards,
Srini

Was this reply helpful? Yes No