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
Thank you very much It's work
Best Regard
Chaiya
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