Control drop down menu on user input

AppSheet AppSheet Q&A
1

Hello,
Can we have a function where if the user input number 2 or any other number then the following drop-down should give the user to select only 2 Customer from the whole list?

Please let me know is it possible and what function I can use?
Thanks!

2

Answered here as well… Yes you can do that with the TOP expression. Like TOP(TableName[ColumnName],2).

2 Likes
3

Hahaha…Thanks @Aleksi

4

You’re welcome