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 / Add to time in sharepo...
Power Automate
Answered

Add to time in sharepoint list

(0) ShareShare
ReportReport
Posted on by 105

Hi. I have a sharepoint list with the following columns.

 

Status - Choices of Pass, Fail, Pending

Due Date

Completion Date

 

I've been working on updating the list via power automate 'When an item is created or modified'

 

i.e change Status 'Pass' to 'Pending', Delete Completion Date and then add 1 year to Due Date. 

 

This flow works fine.

 

AM1974_0-1699005414155.png

 

However, when I try to schedule the flow to run monthly and Get Items, ie. find anything where Status = Pass, I cannot get it to work. The variable i set up in the above flow, automatically goes to Apply To Each then it wont work.

 

I can get other sharepoint colums to update. ie. Status change from Pass to Pending, Set completion date back to blank, but I cant get it to now add one year to Due Date.

 

AM1974_1-1699006097762.png

 

Any help much appreciated.

Categories:
  • CFernandes Profile Picture
    8,504 Most Valuable Professional on at

    @AM1974 - Please move the Initialize variable below the "Get items actions" (outside the loop).

     

    Inside the loop use the "Set variable" action and pass the Due date.

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

  • AM1974 Profile Picture
    105 on at

    Where do I put intialise variable then please? Everytime I add Initialise Variable, it automatically goes in to ApplyToEach

  • AM1974 Profile Picture
    105 on at

    within my Get Items, there is a filter query which is Status eq 'Pass'

  • Verified answer
    CFernandes Profile Picture
    8,504 Most Valuable Professional on at

    Hey @AM1974 

     

    Please check the screenshot below - 

     

    CFernandes_0-1699009996272.png

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

     

  • AM1974 Profile Picture
    105 on at

    Hi CFernandes

     

    Thank you so so much for your help. This worked. I really appreciate your time and assistance.

     

    AM1974

  • CFernandes Profile Picture
    8,504 Most Valuable Professional on at

    Hey @AM1974 - I am glad that your problem is resolved 🙂

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 315 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 267

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard