web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / A value must be provid...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by DebelJ 6

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

Flow 1.PNG

Flow 2.PNG

Flow 3.PNG

Flow 4.PNG

Flow 5.PNG

Flow 6.PNG

Flow 7.PNG

 

 

 

 

Flow 8.PNG

The Raw Inputs say:

DebelJ_0-1668145545258.png

 

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",
                "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",
                "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",
                    "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",
                    "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"
    }
}
Categories:
Building flows
I have the same question (2)
  • MarvinBangert Profile Picture
    MarvinBangert 1,924 Most Valuable Professional on at

    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:

    MarvinBangert_0-1668373077327.png

    "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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans