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.

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.

Any help much appreciated.