web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Compare current year f...

Power Automate

Answered

Compare current year from Sharepoint List

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I'm a beginner power platform I need to know how to Compare Current Year from Sharepoint List and Create Current Year if Data not have Current Year

Example

Product	Year
Car	2021
Car	2022
Bike	2022

If flow check Car and Bike not Matching Current year Flow will Create New Record with Current Year

Product	Year
Car	2021
Car	2022
Bike	2022
Car	2023
Bike	2023

Best Regard

Chaiya

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Chaiyasavework1 ,

Is there a column named Year in your table, and you want to determine whether the Year of the items in the table is the current year, and if not, add a new item?
You can use the following formula in flow to get the current year.
formatDateTime(utcNow(),'yyyy')

Best Regards,
Dezhi

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you very much It's work

Best Regard
Chaiya

Was this reply helpful? Yes No

Join the conversation