Answered

Add a Row Into a Table - 'Value must be provided for item' Error

(0) Share

Report

Posted on by CU18091915-0

Hello,

I am using PowerAutomate to fetch data from a Sharepoint List and turn it into an excel file, which is then sent via email.

Despite having an identical working flow for another process, this one is failing on the Add a Row Into a Table Action.

Let me know if more info is needed to determine. The error code is a bit esoteric, and I'm not sure what it's indicating is the issue.

The relevant segment of the flow looks like this:

The Apply to Each action:

Output is from the body of the Select - Choose Columns action;

Id is from the output of the Create File action

name is from the output of the Create Table action.

When it runs, I receive the error, "A value must be provided for item:"

More failure details:

Body of failure output:

{
  "status": 400,
  "message": "A value must be provided for item.\r\nclientRequestId: 768d6254-385f-4957-bf00-cd7e682c6afb",
  "error": {
    "message": "A value must be provided for item."
  },
  "source": "excelonline-wus.azconn-wus-001.p.azurewebsites.net"
}

Categories:

Building flows

I have the same question (3)

All responses (6)

Answers (2)

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report

There is no way to know since you don't show the entire JSON for the row field in the Add a row into a table action, but do you have a column in your spreadsheet named Item? If so, the error indicates that you did not populate a value for this column for one or more items in the apply to each. If this field can be empty, try using a coalesce() expression to populate the item column. You can learn about this expression at Blank, Coalesce, IsBlank, and IsEmpty functions - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
CU18091915-0 39 on at

Like (0)

Report

Hey @David MA,

Thanks for taking a look and for the suggestions.

The output can definitely have blanks per the process, but in this case, none did and it still failed.

Let me know if I can provide more info to help with troubleshooting.

"do you have a column in your spreadsheet named Item?"

Are you referencing the Select action? Each of the columns are populated with this formula, adjusted for column names:

Row JSON output:

{

  "PR-Line_Concat": 1,

  "VN-MMID_Concat": 1,

  "Purchase_Requisition_Number": 1,

  "PR _Line_#": 1,

  "Block_Stock_(Y/N)": "Blocked",

  "PR_Create _Date": "5/25/25",

  "MMID": 1,

  "Material_Description": "d",

  "MPN": "11",

  "UOM": "1",

  "Material_Status": "11",

  "Material_Group": 1,

  "Vendor_#": 1,

  "Vendor_Name": "1",

  "Plant": "1",

  "Original_PR_Requested_Date": "1",

  "Lead_Time": 1,

  "PO_Delivery_Date": "1",

  "Original_PR_Quantity": 1,

  "SOQ": 1,

  "PO_Order_Quantity": 1,

  "Material_True_Price": 1,

  "PO_$Amount": 1,

  "ROUND_UP_EXCEPTION_TYPE": "1"

}

Was this reply helpful? Yes No
Pstork1 68,759 Most Valuable Professional on at

Like (1)

Report

The problem is because you are using a dynamic value for the file and table. As a result the action can't pick up the schema of the row when you create the connection. So you have to provide the row as a record with the key item:. You are providing he record itself, but not including the keyname Item: Try adding

{item:

in front of the current item dynamic content and then following it with a closing

}

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
CU18091915-0 39 on at

Like (0)

Report

Hello pstork1,

Thanks for the reply!

I'm trying to add that as an expression, but it's not taking. Any advice? I might be misunderstanding the ask.

Was this reply helpful? Yes No
Verified answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report

It seems like @pstork1 is familiar with the method you are using to add the rows to the spreadsheet you created. I do it a bit differently and format the JSON within the add a row action in the apply to each:

It is based on the method shown here https://youtu.be/RB_ySjhm9Sg?si=whabyQ2rntuPIo-u. In this solution, all of the fields I am populating in the spreadsheet are required fields in SharePoint, so I don't need to worry about any empty value, but I would use coalesce if some were not required.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,759 Most Valuable Professional on at

Like (1)

Report

@CU18091915-0 You still need to use the Expressions tab and the dynamic content entry. Items('Apply to each) would be the array of items, not the current item that you were trying to use in your previous example. You'll probably also need to do a data select to get the fields to match the ones in Excel. Or as @David_MA's last example did build your own record from scratch with the individual dynamic content entries.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No