web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate trigger...
Power Automate
Unanswered

Power Automate trigger fails with multi-value Person field on specific SharePoint list

(0) ShareShare
ReportReport
Posted on by
Hi everyone,
I have a Power Automate workflow using the SharePoint trigger "When an item is created or modified" that works perfectly on my DEV environment but fails on PROD with the following error:
The API 'sharepointonline' returned an invalid response for workflow operation 
'When_an_item_is_created_or_modified' of type 'OpenApiConnection'. 
Error details: 'The API operation 'GetOnUpdatedItems' requires the property 
'body/value/0/zzz' to be of type 'Object' but is of type 'Null'.'
 
Details:
I have Sharepoint 2016 on Prem.
"zzz" is a mandatory multi-value Person field  - it is always populated
Both DEV and PROD lists have the same column configuration (multi-value Person field, required, People Only)
The PROD list has approximately 25 columns  - not unusually large
Tested with both "When an item is created" and "When an item is created or modified" triggers on PROD  - both fail
The error occurs even on newly created items where "Requested By" is populated
 
Question:
 
Why does the trigger work on DEV but not PROD with identical column configuration? Is there a way to exclude a specific column from the trigger schema validation without using views? What can I do to make that trigger work?
Any help is appreciated.
 
Thank you!
Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,891 Most Valuable Professional on at
     
    You mention that the DEV and PROD lists have the same column configuration.

    Just to double check. Have you checked the internal name of both zzz columns? Are they actually the same.

    https://elliskarim.com/2021/12/20/finding-the-internal-name-of-a-sharepoint-column/


     
    Happy to help out 😁

    I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard