DropDown List with Distinct function

[jfiszer110]

I've a SharePoint List with a column containing dates in the dd/mm/yyyy formwat. I need to create a DropDown populated with the Month only from the dates in that column. I was able to get the DropDown to work by returning the ## of the month, but as soon as I try to format it as the text of that month e.g. March, November, etc. the DropDown stops returning the same results. Why is this happening and how do I correct it?

• Screenshot 1 is the DropDown functioning with ## representing the month
• Screenshot 2 is the DropDown mal-functioning with text representing the month

[mdevaney · Accepted solution]

@jfiszer110 

I don't think the Month function is necessary here.  Drop it and simply use Text instead.

Distinct(PwrAppSalesData, Text(DatePick, "mmmm"))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[jfiszer110]

Bingo!  Thank you.