Expression to set column or list all

How should I form an expression in an App Formula to set the value of a dropdown (ref) list based on the value of another column AND if the value does not match then list all of the values in the drop down. This expression works, with one problem Iโ€™d like to solve:

IF([TranType]=โ€œTRANSFERโ€,โ€œCash Transferโ€ ,Items[Name])

This is set in the App Formula of the โ€œItemโ€ column, which is a dropdrown ref containing the list of values from the Items table. If the TranType column = โ€œTRANSFERโ€ set this col to โ€œCash Transferโ€ else List the Names from the Items table.

The problem is that it just sets the Item column to all of the values in a comma delimited list, instead of a dropdown format. Any help will be greatly appreciated by this newby.

Solved Solved
0 2 127
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

Set Valid If to:

IF(
  ("TRANSFER" = [TranType]),
  LIST("Cash Transfer"),
  Items[Name]
)

Then set Initial value to:

IFS(
  ("TRANSFER" = [TranType]),
    "Cash Transfer"
)

Optionally set Editable? to:

("TRANSFER" <> [TranType])

See also:






View solution in original post

2 REPLIES 2

Steve
Platinum 5
Platinum 5

Set Valid If to:

IF(
  ("TRANSFER" = [TranType]),
  LIST("Cash Transfer"),
  Items[Name]
)

Then set Initial value to:

IFS(
  ("TRANSFER" = [TranType]),
    "Cash Transfer"
)

Optionally set Editable? to:

("TRANSFER" <> [TranType])

See also:






Thanks, so much. Works great.

Top Labels in this Space