I tried to create an approval flow while updating a column, but the first step itself is not triggering at all and showing errors in the flow checker like this. "ResponseSwaggerSchemaValidationFailure. The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_or_a_file_is_modified' of type 'OpenApiConnection'. Error details: 'The API operation 'GetOnChangedItems' is missing required property 'body/value/0/Title'.'". Anyone please help on this matter.

Hi @Basil P. Joy Do you create the flow from template？ If yes, you could try to recreate it from blank. Or you could check if the "Titile" field in the changed item is set blank. Review the items in the list and fill that title field that may have another label but originally the field was called title. You could edit the column settings as the screenshot to enforce the field to be filled in by going to list settings> Title If the answer is helpful, please click " Accept Answer " and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

When an item or a file is modified is not triggering

Accepted answer

Yi Lu_MSFT 17,461 Reputation points

2021-10-28T07:18:24.93+00:00

Hi @Basil P. Joy
Do you create the flow from template？ If yes, you could try to recreate it from blank.

Or you could check if the "Titile" field in the changed item is set blank. Review the items in the list and fill that title field that may have another label but originally the field was called title.

You could edit the column settings as the screenshot to enforce the field to be filled in by going to list settings> Title

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Basil P. Joy 46 Reputation points

2021-10-28T07:57:12.487+00:00

Hi @Yi Lu_MSFT

Yes I created it from blank and the title column same as like in the screenshot. But I didn't add the title field in the form it is hidden because don't need of tittle field in my requirement. I hope title field will be blank if we are not filling it. Is there any way to dynamically fill the same from back end ?

Yi Lu_MSFT 17,461 Reputation points

2021-10-29T09:25:18.297+00:00

Hi @Basil P. Joy
You could use the following code to fill in the exsiting item "Title"

#Config Parameters $SiteURL="https://crescenttech.sharepoint.com" $ListName="list" #Setup Credentials to connect $Cred= Get-Credential $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password) #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = $Credentials #Get the List $List=$Ctx.Web.Lists.GetByTitle($ListName) #Get All List items $ListItems = $List.GetItems([Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery()) $Ctx.Load($ListItems) $Ctx.ExecuteQuery() #sharepoint online powershell loop through list items Foreach ($Item in $ListItems) { $Item["Title"] = "Project Darwin" $Item.Update() $Ctx.ExecuteQuery() write-host "Item Updated!" -foregroundcolor Green }

Then the value in "Title" will be the same:

What's more, you could set a default value for "Title" value:

In this way, you will not need to fill in "Title" column manually. When you create a new item, the value in the field will be default value, instead of be blank.

Yi Lu_MSFT 17,461 Reputation points

2021-11-02T02:19:20.233+00:00

Hi @Basil P. Joy
Have you tried the two steps I provided for you? If you have some doubts about it, please feel free to reply.

Basil P. Joy 46 Reputation points

2021-11-08T14:05:10.93+00:00

Hi YiLu-MSFT,

Thank you so much, the problem was because of the empty title field and I made the default value as something like you mentioned in the second step. Now my problem is solved and a big thanks for you.
Sign in to comment

When an item or a file is modified is not triggering

0 additional answers