web

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

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Fetch Unique Month fro...

Power Apps - Building Power Apps

Unanswered

Fetch Unique Month from Filtered Date Column

Like (1) Share

Report

Report

Posted on 18 Apr 2022 13:43:44 by Laxmikant_Alle

79

Hello there,

I want to show the unique month name in dropdown from filtered data which should be in ascending order.

can anyone please guide me on how to do the same?

Thanks in Advance.

Categories:

General Questions

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Drrickryp Super User 2024 Season 1 on 18 Apr 2022 at 14:03:22

Like (0)

Report
Re: Fetch Unique Month from Filtered Date Column

@Laxmikant_Alle

Please post a screenshot of the data you want to shape in your dropdown. For a complete explanation of PowerApps date and time functions see @mdevaney 's blog here: https://www.matthewdevaney.com/all-power-apps-date-time-functions-with-examples/

For a dropdown with months and month number put

With( { data: RenameColumns( Calendar.MonthsLong(), "Value", "MonthName" ) }, ForAll( Sequence(12), Patch( Last( FirstN( data, Value ) ), {MonthNumber: Value} ) ) )

As the Items property of the dropdown.

Was this reply helpful? Yes No