Having trouble combining lists

AppSheet AppSheet Q&A
1

I am trying to combine two lists do determine and Edit action ability. However, it seems to be ignoring the first item in the second list. Please note the double-quotes around Created By in the expression assistant:

Scott_Nesbitt_0-1703871452254.png
Scott_Nesbitt_0-1703871452254.png938×384 27.7 KB

If I add a dummy item before the first item it works:

Scott_Nesbitt_1-1703871512104.png
Scott_Nesbitt_1-1703871512104.png936×389 26.1 KB

Is this a bug?

2

Insted of “+”, you should use “,” inside of the list { }. Quite often is better to write the list using the LIST() expression like LIST([Created By],[Sales Manager],..)

2 Likes
3

Switching to LIST() and commas fixed the issues, thanks for the tip.

4

You’re welcome!