Power Automate

Add Row to Excel table is raising error "A value must be provided for item"

(0) Share

Report

Posted on by johnjohnPter

2,015 Season of Giving Solutions 2025

I have this table inside excel, where it contain 3 columns (A,B,C), where 3rd column C contain a formula:-

now using power automate i want to add rows inside this table so i wrote this action:-

but got this error:-

{
  "status": 400,
  "message": "A value must be provided for item.\r\nclientRequestId: 7eb3a564-7f6a-42f2-a582-5a82aff4857d",
  "error": {
    "message": "A value must be provided for item."
  },
  "source": "excelonline-scus.azconn-scus-001.p.azurewebsites.net"
}

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

It looks like the formula in that column is in the cell of the first row, and not the header row. Power Automate has a known issue working with cells that have formulas. The formula needs to be a table formula that applies to the whole column. Not just a cell formula. Take a look at this post on doing calculated columns in Excel Tables. Use calculated columns in an Excel table - Microsoft Support

----------------------------------------------------------------------------------
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
Suggested answer

Riyaz_riz11 4,204 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

Make sure both fields are not empty your dynamic values must return data add compose and check the value you getting value and also add "" between the values.

I wish you're pass anything for column C.

Check column names match exactly same spelling and spaces as in Excel table.

Make sure your dynamic content like Current item is inside a loop and actually has values in Microsoft Power Automate.

Note: Make sure Name and Calls-Start-10 fields are not empty your dynamic values must return data.

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No