Changing a choice field when date is a year old

[KyleJackDaniel1]

Hello,

I've done a lot of googling and struggling to find a working solution to my problem.

I'm trying to find a flow that when a date in my SharePoint list column "PAT Test Date" is Today()-365, to change the choice column "PAT Tested" to "Expired".

Kind regards,

Kyle

[Hardesh15 · Accepted solution]

@KyleJackDaniel1  Create one scheduled flow that will run everyday and then use get items with filter query so that you can get required item. after that update your item.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[KyleJackDaniel1]

Its the expression which I mainly struggle with, Its different to excel/PowerApps.

if('PAT Tested Date'>Today()-365,'PAT Tested'.Value="Expired",'PAT Tested'.Value)

Trying to get that, to work with a Power Automate Filter Query.

Is this correct?

(PATTestedDate lt '@{addDays(utcNow(),-365)}')

[KyleJackDaniel1]

Managed to do it thank you,

I enabled "Experimental Features" by going to "Settings" > "View all Power Automate Settings" > "Enable Experimental Features" which made the filter query a lot easier to understand.