Unanswered

SQL Server Not Finding Columns

(0) Share

Report

Posted on by Zap174

167

I have a flow to insert rows into a db using the SQL Server connector. It was working fine before, but now, it displays this error message:

Where ContactID is the primary key in the table and I can see the column in the table itself so it is definitely present. If I follow the instructions and remove the field, this message appears:

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Insert_row_(V2)_3': The API operation 'PostItem_V2' is missing required property 'item/ContactID'.'.

Requiring that I need to insert the field when writing the row. Which contradicts the other statement.

Is this a bug? Has anyone else experienced something like this?



Categories:

General topics

All responses (3)

Answers (0)

Sort by

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there,

It looks like it is a bug. I found previous posts from folks who tried to delete & recreate, and in the end, had to entirely recreate their flows.

https://powerusers.microsoft.com/t5/Building-Flows/Field-is-no-longer-present-in-the-operation-schema-Flow-un/td-p/1301280

This one has the same issue, but re: SP ... and an angry person, which is always fun.

https://powerusers.microsoft.com/t5/General-Power-Automate/You-broke-my-flow/td-p/386521

It also seems that if the properties are changed for the field, it can "disconnect", and needs to be reconnected.

I hope something there will at least start us on the right path to resolution!

Cheers,

Rhia
Zap174 167 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rhiassuring

Thanks for the info! The bug seems to have been solved on my end. The unique identifier returned to the schema and everything works as planned.
Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome! Did it resolve over night or did you need to do anything to get the identifier back?