Convert datetime column into year column

(0) Share

Report

Posted on by Community Power Pla...

Hello guys, I need your help.

I've a column of datetime in Sharepoint list. I want to use this column to create dropdown of a year in the list.

This is what i want.

What I think is I need to create a collection from Sharepoint list with datetime column and convert this column in to year (use Year function) then use Distinct function to filter out the duplicate.

My collection name yearyear and the column name is DateofOccurence.

The problem is Year function is not enable to convert table.

Please help me to convert my datetime column in the collection to year column.

Or any advise to complete this is very helpful.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Hi @Anonymous

You could add the following code to the Items property of your dropdown:
Distinct( AddColumns( colDates, "Year", Year(ThisRecord.Value) ), Year )

However, you could also fix this by creating a year collection and using the distinct of those values:

ForAll( colDates, Collect( colYearOfDates, Year(ThisRecord.Value) ) )

I hope this helps!

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

Like (0)

Report

Thanks!!! LaurensM

This is really solved my problem.

Wish you have a good day!

Was this reply helpful? Yes No