Showing results for 
Search instead for 
Did you mean: 
New Member

SharePoint Lists with multiple content types - missing required property

I have 2 content types in the same list:
Content Type A:
* Field A (required)
* Field B
Content Type B:
* Field A (NOT required - in fact should always be empty as it's not relevant for this content type. I tried both not adding this field and making it hidden / optional)
* Field C
When I try to send out a Teams message referencing Field A when creating a new Content Type B:
ResponseSwaggerSchemaValidationFailure. The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'. Error details: 'The API operation 'GetOnNewItems' is missing required property 'body/value/0/Field_x0020_A'.'
How can I tell Flow that it's OK to ignore Field A? Explicitly branching doesn't work either.

Frequent Visitor


I had a similar problem and resolved it by removing direct 'dynamic content' references to the sometimes-missing column. I replaced them with a Concat expression taking the column name and '' as follows:

  • concat(triggerOutputs()?['body/column_name'],'')


I hope this helps.

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,602)