Number Year Selector

Free

A year-picker dropdown for Whole Number columns in Dynamics 365 and Power Apps - no typing, no comma formatting.

Whole Number columns are the natural place to store a year, but they come with an awkward side effect: the moment a user types a value like 2030, Dynamics 365 applies the org's number-format settings and shows it as 2,030. A thousands separator makes sense for quantities and amounts - it makes no sense for a year. Year Selector replaces the plain number input with a configurable dropdown built from a Start Year and an End Year you define. It generates one option per year across the inclusive range, so users select a year instead of typing it, every option renders without grouping, and the field writes back a clean integer - 2030 always looks like 2030. Built in plain TypeScript with zero dependencies and styled to match native Fluent fields, it drops into any model-driven form.

What Pain It Solves

Key benefits:

  • Eliminates thousands-separator formatting on year fields - 2030 always reads as 2030, never 2,030
  • Configurable range via two integer parameters, Start Year and End Year, that build the dropdown across the inclusive span
  • Single selection only, so the bound Whole Number column keeps a clean integer value
  • Preserves an existing out-of-range value as a selectable option instead of silently clearing data, and collapses to a single option when Start Year equals End Year
  • Styled to match native Fluent fields - filled background, brand-accent focus underline, native chevron - with zero dependencies (no React, no external libraries)

Perfect For

Validity & expiry yearsFiscal & budget yearsModel yearsContract yearsReporting periodsModel-Driven Apps

Screenshots & Demo

Number Year Selector Screenshot 1

Browse through screenshots and watch the demo video

Download Number Year Selector

This control is free to use. No license required!

Download Control

Need help with implementation?

Contact us to discuss how we can help integrate this control into your organization.

Contact Us