A value must be provided for item. clientRequestId: fa904eb5-dfe4-44f6-927c-8f876a0e103a

[DebelJ]

Hi I need help with a flow.  Every month I want a sharepoint list to be saved to an excel spreadsheet.  I have created the flow below however it keeps coming up with an error

A value must be provided for item.
clientRequestId: fa904eb5-dfe4-44f6-927c-8f876a0e103a

I cannot work it out and am seeking assistance.

I look forward to hearing from you.

Thanks Debelj

 

 

 

 

   The Raw Inputs say: 

The Raw Inputs say:

    "host": {

        "connectionReferenceName": "shared_excelonlinebusiness_1",

        "operationId": "AddRowV2"

    },

    "parameters": {

        "source": "groups/df1c1c28-0cf0-480f-bcb9-5e78b267a9eb",

        "drive": "b!Bckw7fQdhUeNgoOOv8EGzQhgXGSvaBBFtYFShgXlBsdzmaj3lPMgSbXOS_s-nrE9",

        "file": "/Shared Documents/Digital Portfolio/project reporting/ICT Dashboard Backup/Backup-2022-11-11T15_26_11.xlsx",

        "table": "'{279234EC-6429-4C57-B90F-6D0CF5D499F3}'",

        "item": {

            "ID": 467,

            "Agency": null,

            "Accountable Officer": null,

            "Achievements": null,

            "Acronym": null,

            "Activity type": [],

            "Cost to date": null,

            "Actual end date": null,

            "Actual start date": null,

            "Application": null,

            "Approval Status": "Pending",

            "Approver Comments": null,

            "Assurance level": null,

            "Board Meeting": null,

            "Budget fy 201314 Capital": null,

            "Budget fy 201314 Operating": null,

            "Budget fy 201415 Capital": null,

            "Budget fy 201415 Operating": null,

            "Budget fy 201516 Capital": null,

            "Budget fy 201516 Operating": null,

            "Budget fy 201617 Capital": null,

            "Budget fy 201617 Operating": null,

            "Budget fy 201718 Capital": null,

            "Budget fy 201718 Operating": null,

            "Budget fy 201819 Capital": null,

            "Budget fy 201819 Operating": null,

            "Budget fy 201920 Capital": null,

            "Budget fy 201920 Operating": null,

            "Budget fy 202021 Capital": null,

            "Budget fy 202021 Operating": null,

            "Budget TOTAL Capital": null,

            "Budget TOTAL Operating": null,

            "Business Impact": null,

            "Business unit": null,

            "Communication": null,

            "Communication Summary": null,

            "Content type": {

                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",

                "Id": "0x012000FF2D46B367357140B50469D4533C5642",

                "Name": "Folder"

            },

            "Cost health": null,

            "Cost Summary": null,

            "Create Date": null,

            "Created": "2018-02-05T00:17:41Z",

            "Created By": {

                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

                "Claims": "i:0#.f|membership|renee.usher@resources.qld.gov.au",

                "DisplayName": "Renee Usher",

                "Email": "Renee.Usher@resources.qld.gov.au",

                "Picture": "https://itpqld.sharepoint.com/sites/ICTDash/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Renee.Ushe...",

                "Department": "Office of the Executive Director",

                "JobTitle": "Manager, Strategy & Transformation"

            },

            "Date data current at": null,

            "Display to public": null,

            "Drivers": null,

            "Editors Notes": null,

            "Exp to date  TOTAL Capital": null,

            "Exp to date TOTAL Operating": null,

            "Exp to date fy 201314 Capital": null,

            "Exp to date fy 201314 Operating": null,

            "Exp to date fy 201415 Capital": null,

            "Exp to date fy 201415 Operating": null,

            "Exp to date fy 201516 Capital": null,

            "Exp to date fy 201516 Operating": null,

            "Exp to date fy 201617 Capital": null,

            "Exp to date fy 201617 Operating": null,

            "Exp to date fy 201718 Capital": null,

            "Exp to date fy 201718 Operating": null,

            "Exp to date fy 201819 Capital": null,

            "Exp to date fy 201819 Operating": null,

            "Explanatory Notes": null,

            "Funding Source": [],

            "Implementation partners": null,

            "Initiative name": "DES",

            "Initiative stage": null,

            "Initiative type": null,

            "Investment objectives": null,

            "Issues health": null,

            "Issues summary": null,

            "Milestone": null,

            "Modified": "2018-02-05T00:17:41Z",

            "Modified By": {

                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

                "Claims": "i:0#.f|membership|renee.usher@resources.qld.gov.au",

                "DisplayName": "Renee Usher",

                "Email": "Renee.Usher@resources.qld.gov.au",

                "Picture": "https://itpqld.sharepoint.com/sites/ICTDash/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Renee.Ushe...",

                "Department": "Office of the Executive Director",

                "JobTitle": "Manager, Strategy & Transformation"

            },

            "Months": "0",

            "Project Commencement allocation": null,

            "Overall health": null,

            "Panel": null,

            "Percentage Complete": null,

            "Approved End Date": null,

            "Previous End Dates": null,

            "Primary digital priority": null,

            "Priority Agency": null,

            "Product": null,

            "Project or Program Manager": null,

            "Quality Health": null,

            "Quality Summary": null,

            "Resources Health": null,

            "Resources Summary": null,

            "Approved Expenditure": null,

            "Risk Health": null,

            "Risk Summary": null,

            "Scope Health": null,

            "Scope Summary": null,

            "Start to Spend Date": null,

            "Strategic Alignment": null,

            "Timeframe Health": null,

            "Timeframe Summary": null,

            "Times rebaselined  Financials": null,

            "Times rebaselined Timeline": null,

            "Exp to date fy 201920 Capital": null,

            "Exp to date fy 201920 Operating": null,

            "Exp to date fy 202021 Capital": null,

            "Exp to date fy 202021 Operating": null,

            "Exp to date fy 202122 Capital": null,

            "Exp to date fy 202122 Operating": null,

            "Exp to date fy 202223 Capital": null,

            "Exp to date fy 202223 Operating": null,

            "Budget fy 202122 Capital": null,

            "Budget fy 202122 Operating": null,

            "Budget fy 202223 Capital": null,

            "Budget fy 202223 Operating": null,

            "Item type": {

                "@odata.etag": "\"7\"",

                "ItemInternalId": "467",

                "ID": 467,

                "Title": "DES",

                "ActivityType": [],

                "ActivityType@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",

                "ActivityType#Id": [],

                "ActivityType#Id@odata.type": "#Collection(Int64)",

                "Created": "2018-02-05T00:17:41Z",

                "Author": {

                    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

                    "Claims": "i:0#.f|membership|renee.usher@resources.qld.gov.au",

                    "DisplayName": "Renee Usher",

                    "Email": "Renee.Usher@resources.qld.gov.au",

                    "Picture": "https://itpqld.sharepoint.com/sites/ICTDash/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Renee.Ushe...",

                    "Department": "Office of the Executive Director",

                    "JobTitle": "Manager, Strategy & Transformation"

                },

                "Author#Claims": "i:0#.f|membership|renee.usher@resources.qld.gov.au",

                "FundingSource": [],

                "FundingSource@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",

                "FundingSource#Id": [],

                "FundingSource#Id@odata.type": "#Collection(Int64)",

                "Modified": "2018-02-05T00:17:41Z",

                "Editor": {

                    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

                    "Claims": "i:0#.f|membership|renee.usher@resources.qld.gov.au",

                    "DisplayName": "Renee Usher",

                    "Email": "Renee.Usher@resources.qld.gov.au",

                    "Picture": "https://itpqld.sharepoint.com/sites/ICTDash/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Renee.Ushe...",

                    "Department": "Office of the Executive Director",

                    "JobTitle": "Manager, Strategy & Transformation"

                },

                "Editor#Claims": "i:0#.f|membership|renee.usher@resources.qld.gov.au",

                "Months": "0",

                "{Identifier}": "Lists%252fICTDash%252fDES",

                "{IsFolder}": true,

                "{Thumbnail}": {

                    "Large": null,

                    "Medium": null,

                    "Small": null

                },

                "{Link}": "https://itpqld.sharepoint.com/sites/ICTDash/Lists/ICTDash/DES",

                "{Name}": "DES",

                "{FilenameWithExtension}": "DES",

                "{Path}": "Lists/ICTDash/",

                "{FullPath}": "Lists/ICTDash/DES",

                "{ModerationStatus}": "Pending",

                "{ContentType}": {

                    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",

                    "Id": "0x012000FF2D46B367357140B50469D4533C5642",

                    "Name": "Folder"

                },

                "{ContentType}#Id": "0x012000FF2D46B367357140B50469D4533C5642",

                "{HasAttachments}": false,

                "{VersionNumber}": "6.0"

            },

            "Path": "Lists/ICTDash/"

        }

The Raw Outputs say:

{

    "statusCode": 400,

    "headers": {

        "Pragma": "no-cache",

        "xms-request-id": "fa904eb5-dfe4-44f6-927c-8f876a0e103a",

        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",

        "X-Content-Type-Options": "nosniff",

        "X-Frame-Options": "DENY",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "true",

        "x-ms-apihub-obo": "false",

        "Cache-Control": "no-store, no-cache",

        "Date": "Fri, 11 Nov 2022 05:26:39 GMT",

        "Content-Length": "268",

        "Content-Type": "application/json",

        "Expires": "-1"

    },

    "body": {

        "status": 400,

        "message": "A value must be provided for item.\r\nclientRequestId: fa904eb5-dfe4-44f6-927c-8f876a0e103a",

        "error": {

            "message": "A value must be provided for item."

        },

        "source": "excelonline-ae.azconn-ae-001.p.azurewebsites.net"

    }

}

[MarvinBangert]

Hi @DebelJ 

I guess the error comes up because you don't provide the information about the item you want to add. Usually, when you select the table, you will see Power Automate resolving the columns from the file. Because you don't provide a value, but a dynamic value, you should see a "row", where you need to enter your information. This element is missing in your screenshot. Try to readd the custom value of table, if it works, otherwise readd file and table or create a new action. If you don't provide this information, the flow doesn't know what value to put into the table. The information must be in json, here is an example:

"TestCol" is my Columnname and "Test123" is my value. Your json will probably look more like this:

{
    "TestCol": "Test123",
    "TestCol2": "Test234",
    "TestCol3": "Test345"
}

Does this help you? Otherwise please give me some more information.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Blog: Cloudkumpel