If you basically want to show dropdown with dynamic values you might take a look at the ‘Grid Search’-widget in the App Store/ Marketplace. You can find it here: https://marketplace.mendix.com/link/component/49364
This package contains multiple widgets, one of them is the ‘Dynamic Dropdown’. This can work combined with the suggestion of Lukas. You should check the documentation of the widget for more information.
Priyanka Rane check this widget https://marketplace.mendix.com/link/component/120198