Dropdown selection with QUERY function

[AlexShevyakov]

Hi,
One of my spreadsheets contains the following structure:
Two columns, A and B (see pic below)

Column A contain the parameter names
Column B contain the parameter values, which are populated when value B1 (dropdown) is selected by user.

When B1 is selected, cell B2 uses QUERY function to pull the data into the rest of the rows below in colum B.
This all work fine in Google sheet but I seem to have problem of bringing this functionality into AppSheet.
Any help would be apprecited.