Changing a choice field when date is a year old

(0) Share

Report

Posted on by 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

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
KyleJackDaniel1 41 on at

Like (0)

Report
Copy link

Link copied!
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)}')

Was this reply helpful? Yes No
KyleJackDaniel1 41 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No