Power Automate

Add row to excel tablee

(0) Share

Report

Posted on by KennethClark

Help with my error.

Flow:

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

rzaneti 4,483 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Is this happening to all of Apply to each items? If yes, what are the data types of these columns coming from SharePoint?

I ran some tests from my end and this error happens when your input has a column structure different from the table (which seems not to be the case) or when you add a invalid value to the table.

Was this reply helpful? Yes No
KennethClark 39 on at

Like (0)

Report
Copy link

Link copied!

All of them are strings (text) in sharepoint list.

what do you mean when i add invalid value?

Was this reply helpful? Yes No
Suggested answer

rzaneti 4,483 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

By invalid value I mean any data type not accepted by Excel in this operation, such as objects. In your case all values are valid, since you are working exclusively with text columns.

Anyway, I ran some additional tests and it looks like the # in your columns name can be a problem. Whenever I tested with the #, the flow failed with the same error message, which disappeared when I removed this special character. For some reason, the flow creates the table normally (without returning any error in the Create table action), but fails when adding the record:

Now without the #:

Are you able to drop the # from your column name in Excel? If yes, then you can just rename the columns in your flow. If not, I recommend you to still remove the special character from the columns name in the flow, and add a later Run script action to rename the columns, then including the #.

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/

https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No