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:

Business Process Flows

Licensing

Flow Mobile App

export_error.jpg

All responses (3)

Answers (0)

Srini007 2,766 on at

Like (0)

Report

Power Automate Extract SharePoint List items to Excel using HTTP

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
CU21110735-0 2 on at

Like (0)

Report

Power Automate Extract SharePoint List items to Excel using HTTP

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.
Srini007 2,766 on at

Like (0)

Report

Power Automate Extract SharePoint List items to Excel using HTTP

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

Power Automate Extract SharePoint List items to Excel using HTTP

Helpful resources

News and Announcements

Quick Links

November 2024 Newsletter…

Community Update Oct 28…

Tuesday Tip #7 Community Profile Tips…

more Community News

Leaderboard

Featured topics

Product updates

Power Automate Extract SharePoint List items to Excel using HTTP

Helpful resources

News and Announcements

Quick Links

November 2024 Newsletter…

Community Update Oct 28…

Tuesday Tip #7 Community Profile Tips…

more Community News

Subscribe to

Leaderboard

Featured topics

Product updates