Answered

Distinct Dates in a Label Even Possible?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Is it possible to display Distinct dates in a label or text input?

I have a SharePoint list with several columns, including a Date/Time column, called Story_Date.

In my Canvas app, the user is able to filter the SP list items from the list (called Ascertainments), into a Gallery (called Stories_Gallery).

The formula, Distinct(Stories_Gallery.AllItems, Story_Date) works to filter Distinct dates, when used in a Dropdown, but does not work in a Label or Text Input.

I've been researching this for weeks, with no success. What am I missing here? Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try Placing

Concat( Distinct(Stories_Gallery.AllItems, Story_Date),Result,", ")

in a label

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

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately that doesn't work either. It says "Invalid Argument Type (Date). Expecting a Text Value Instead."

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
In That case it woudl be

Concat( Distinct(Stories_Gallery.AllItems, Story_Date),Text(Result),", ")

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

Like
a
(0)

Report
Copy link

Link copied!

Thank you! This works perfectly.

Was this reply helpful? Yes No