Smartsheet Flow - Insert Row when external Data is created - Error Code 1046

[Strahlemann]

Hi there,

I'm struggling with a problem and I hope one of you guys can help me out here...

I'm trying to insert a Row into a Sheet when external Data is created - in this case I'm monitoring Dynamics CRM for specific updates and I want to add various infomrations into Smartsheet.

I end up with Error Code 1046.

The collected Data is valid and the trigger works perfectly fine.

Only when I'm trying to add a Row into Smartsheet I end up with the followng Error:

Does someone have an Idea how to fix this?

The Sheet itself has none of the mentioned functions, explained in the Error code (so no Grant, Formulas or what so ever) .

The flow itself is build by using a lookup table for linked Data in Dynamics CRM but since I get a valid Output from the dynamics trigger I think the problem is related to Smartsheet...

[v-micsh-msft]

Hi @Strahlemann,

I agree. This issue should be related with the SmartSheet side.

Formulas may be auto-filled when new rows are added, like the contact-list column, or Dependency enabled columns (Start Date, End Date, Duration, % Complete, Predecessors).

Please take a try to clear fields Input, if the field is within the range mentioned above.

Further, for SmartSheet troubleshooting, you may first follow the article below:

Troubleshoointg Guide

If issue insists, then you may consider to seek help from the SmartSheet support.

Regards,

Michael

[Strahlemann · Accepted solution]

After working with Smartsheet Support on this topic (by the way did a great job in supporting me) the following issue was identified:

We have confirmed that when Microsoft Flow makes a request to create a new row in a sheet it includes every column on the sheet in that request, even ones that you don't specify needing data added to them. Because of this the system columns you have in your sheet are being included in the process to create a new row. The Smartsheet API will return this error when making a request to add data into a system column as it is not necessary since Smartsheet will create the appropriate data.

I had two System columns in my Sheet (Created By and Modified Date) where the Smartsheet connector tries to write Data into it - even when nothing is specified in MS Flow to do with those Columns.

Since those are System entries from Smartsheet, the Flow connector actually is not allowed to write into those Cells and therefore the Error Code 1046 will be created.

After removing those System colums everything works now as expected.