web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Convert datetime colum...

Power Apps

Answered

Convert datetime column into year column

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks!!! LaurensM

This is really solved my problem.

Wish you have a good day!

Join the conversation