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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

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.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,350)