How to retrieve a value from a dependent drop down NOT selected in Appsheet

[rafaelpazsud]

I have a dependent drop down menu below (Categories --> Category --> Attribute --> Column Type).
Column type will always display one single value, in the image below it's "STRING".
As you guys can see after selecting "Attribute" "Column Type" appears unselected. I'm having a very bad time trying to automatically selecting it after "Attribute" is selected, however, not able to do it yet. At the moment I can only select "Column Type" clicking on it and I need to be automatically as It will be a hidden property that I will use within an external API, so the user doesn't need to see it.

Can someone please help with that?

[Suvrutt_Gurjar]

Please try in he initial value of the column[Column Type] an expression something like 

ANY(SELECT( Source_Table[Column Type], AND( [Categories]=[_THISROW].[Catgeories], [Category]=[_THISROW].[Category], [Attribute]=[_THISROW].[Attribute])))

Where Source_Table is the table from where the dependent dropdown records or values are referenced in the form you have shown.

[rafaelpazsud]

Thanks @Suvrutt_Gurjar  for your help, however man, it's bringing the wrong Column type.
I've added the ISNOTBLANK there as It was showing all the time the Column type.. I'm still trying to work on your example in order to get the correct value.

cheers

[rafaelpazsud · Accepted solution]

I was able to achieve what I was looking for using the formula below, just in case someone also has the same issue:

SELECT(TB_PROFILE_SCAN[COLUMN_TYPE],AND([VALUE]=[Attribute],ISNOTBLANK([_THISROW].[Attribute])))