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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / When a task is complet...
Power Automate
Unanswered

When a task is completed, update the corresponding row in Sharepoint list

(0) ShareShare
ReportReport
Posted on by 65

Hello, I have a flow that when a task is created in planner, it lists that task in a SP list by bucket name (ID). With my second flow, I am trying to update my "Progress" row in SP list when a task in a particular bucket is completed.

 

The "Progress" row in my SP list is a "Choice" type, and the choices are Not started, In Progress, Completed.

 

I am stuck, I know I am close. Attaching the current error I get when I run the flow. Thoughts? Thank you.

 

Flow1.pngFlow2.pngFlow3.pngErrorError 

 

Categories:
I have the same question (0)
  • alrezac Profile Picture
    on at
    Re: When a task is completed, update the corresponding row in Sharepoint list

    Hi,

     

    Looking through your Flow it appears that the reason that it failed was because no values were returned from your "Get Items 2" because there was no data to run through the apply to each, it failed. As to why it didnt return enough data, I cannot not tell from your flow. This might be a better question for the Microsoft Support team, I'll include a link to create a case with them if you would like to go down that route. Otherwise if any other communities member might have any idea feel free to chime in.

     

    Regards,

     

    Alex

     

    -------

     

    Community Support Team _ Alex Rezac
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Verified answer
    Solomon_c Profile Picture
    65 on at
    Re: When a task is completed, update the corresponding row in Sharepoint list

    @alrez thank you for the response. After a lot of trial and error...I figured it out. Posting below for anyone in future. Overall.pngApplyToEach.pngUpdate.png

  • e-wei Profile Picture
    23 on at
    Re: When a task is completed, update the corresponding row in Sharepoint list

    Hello, can you share, please your solution in details? I am stuck on something similar. I have a SP list with bucket names in columns, but I can not find the right condition to update the task progress status for in the right row and right column. Can maybe somebody guide me here?

  • niki1 Profile Picture
    18 on at
    Re: When a task is completed, update the corresponding row in Sharepoint list

    Hello,

    Can you post your complete flow code for get a task, list buckets and get items?  I am really lost here. Thanks.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard