Handling Date & time column as drop down filter

(0) Share

Report

Posted on by CU04120706-0

Hi All

We have created one canvas app and on the same we have created a drop down filter for user.

Now problem is the column linked to that field is date and time column, so on app under drop down it is showing numbers not actual date and time. We have used the below formula for drop down:

Sort(Distinct(Tablename, Column name),
        SortOrder.Descending
    )
 
Could some one please guide how to update this to show date and time instead of number. Also we looking for solution whenever user open it that will show data basis latest date and time.
 
Regards
Mohit 

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @CU04120706-0,

Please try below formula:

With({ _data: SortByColumns(Tablename,"ColumnName",SortOrder.Ascending) }, Distinct(_data,Text(ColumnName,"mm/dd/yyyy")) )

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

1 people found this reply helpful.

Was this reply helpful? Yes No