Assign first value

Hi. Is there a way (expression) for Appsheet to pick the first value (Row 2) in Google sheet and assign the value to the column?

For example, 

 Product name (Table)               Name (Column in Appsheet): AAA (get the first value in Product name                                                                                                                      table)                                  

  1. AAA
  2. AAB
  3. AAC

 

Solved Solved
0 3 203
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5
LOOKUP(
  MIN(Product table[_ROWNUMBER]),
  "Product table",
  "_ROWNUMBER",
  "Product name"
)

View solution in original post

3 REPLIES 3
Top Labels in this Space