cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
techtudoor
Resolver I
Resolver I

Update SharePoint Task list with Flow

I am wondering if Flow can update a SharePoint Task list? I have a flow that sends emails when a SP Task list item is created and another when the SP Task list item is updated. Now what I want to do, is update a yes/no field in the Task list using Flow. When I add this update item, the trigger fails.

 

I have tried using When an item or file is created, When an item or file is modified and When an item is created or modified. All of these triggers work to send an http request email. They fail once an Update item control is added anywhere in the flow. 

 

Has anyone else ran into this issue? Is there another way to update a SP Task list with Flow, or is this just wishful thinking?

 

Thanks in advance

6 REPLIES 6
annajhaveri
Super User
Super User

@techtudoor  what error are you getting when you use Update Item in the flow? I think you will need to add trigger condition to flow to avoid infinite loop situation.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Hi @annajhaveri , I receive the below error:

 

The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_or_a_file_is_modified_-_Updated_Platform_Change_Control' of type 'OpenApiConnection'. Error details: 'The API operation 'GetOnChangedItems' is missing required property 'body/value/0/V3Comments'.'

 

The field I am trying to update after the Send an http request, would exit the loop and prevent the flow from triggering again until a status change.

 

The Task list may be updated many times until the status changes. The flow triggers when a task is updated however, if the status does not change, the flow would exit with a cancelled message. If the status does change, the flow will run through a Switch to determine which email to send via Send an http request to SharePoint.

@techtudoor  can you share the screenshot of your flow which has update item action, also if possible share screenshot of your flow run which shows the error

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

 

Here is the update item. This is what is causing the error. Once I remove this, the flow works. I just want to update the communication_Sent column to Yes.

 

techtudoor_0-1628276989406.png

 

@techtudoor  has there been any changes in the column settings recently? Can you try removing the Update Item action and add again in the flow and test?

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

@annajhaveri , yes I had added the Communication_Sent field. When I remove the update item action, the Flow runs fine. I am hoping to use this field to prevent emails being sent when an update to the task has been added, but the status has not changed. 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,342)