Enum Drop-down Menu

[Sayad]

I have to make an auto select dropdown menu. I want that if the start value matches with my data sheet, then it should be selected in the dropdown in front of it. Even if there is no value match.

So the dropdown menu should be shown in the form, so that I can select the dropdown myself. 

[Aurelien]

Hi @Sayad 

You may want to consider this for the dependent dropdown part:

https://help.appsheet.com/en/articles/961554-dependent-dropdown

and use an initial value expression for your "auto-select" part. 

Without more context, I suggest a combination of:

https://help.appsheet.com/en/articles/4742175-startswith

https://help.appsheet.com/en/articles/2347632-any

https://help.appsheet.com/en/articles/2357308-filter

It could be something like:

IFS(
  ISNOTBLANK(
    FILTER("yourSourceTable",
      STARTSWITH([descriptionColumnInSourceTable],LEFT(yourCriteria],5))
    )
  ),
  ANY(
   FILTER("yourSourceTable",
      STARTSWITH([descriptionColumnInSourceTable],LEFT(yourCriteria],5))
    )
  )
)

Note: for future posts, please provide screenshot/context.

[Sayad]

see my table details

My enum

enum

startswitch valur table

[Aurelien]

Valid_If:

FILTER("ENUMLIST", [CHANNEL]=[_THISROW].[Channel])

Initial_Value:

ANY(FILTER("ENUMLIST", [CHANNEL]=[_THISROW].[Channel]))