Filter more than 5000 records

Do you really need to show all values in that record? Couldn't you use a different approach¿?

I need to show all values of the record in order to filter and search

Instead of using dropdown, you can use the search filter. If all 45000 records are unique, its not really something that should be provided as a dropdown filter

Hello maria.escalante ,

What is the content that you want to show as options? How likely will they have repetitive words. 

Hi maria.escalante ,

You cannot query 45000 records at once. Try querying batch wise 5000 each time (9 times), and append it to a local variable and use it in dropdown.

Also ensure this will affect the performance. I don't recommend the above method, but it's possible as I've mentioned on top.

Note: Dropdown deoesn't accept duplicate values.

I agree with this, this would be a very bad user experience. Instead if these are going to be unique values you can execute a query once you collect some keywords from the user and search for the records that include those inputs.

Use a search filter as Sarathkumar R suggests, or a diferent option... your option it's not the best one from UX and performance point of view....

Please do not do this. Use a record picker field to allow users to search and pick the values.

I didn't recommend the Record Picker as Appian suggests that we do not use these components where we try to show more than 5000 records. Please correct me if I am wrong.

https://docs.appian.com/suite/help/24.4/Record_Picker_Component.html#row-limit-for-records-powered-components

The point is to not directly show that many items to the user at all. I mean, just from a UX perspective, showing any larger list of data to a user to make selections, is a bad idea.

But using a picker field, the user can search for, and select from a more or less unlimited number of items.