I'm having an issue that i cant work out whereby i want some logic with a dropdown list to show the items from a collection IF the collection has any data in it and if the collection is empty then i would like it to show something else ie ["1","2"]. My formula is below,
If(!IsEmpty(ColPlotPermission),ColPlotPermission,["1","2"])
I am getting this error... "Warning: The Columns produced by this rule are all nested tables and/or records, however the property expects at least some columns of simple values (such as text or numbers)" (See pic attached)
What is strange is that if i just input the following into the items property of the dropdown
If(!IsEmpty(ColPlotPermission),ColPlotPermission)
my dropdown shows the Result column of ColPlotPermissions collection as it should.
also if I input "["1","2"]" into the items property then my dropdown box shows 1 and 2 as you would expect.
i seem to have an issue with when i add the "," to the If statement and the else value (which at the minute i'm just trying the basic "["1","2"]" and its throwing an error.?
Any thoughts? i've played around with this for ages to no avail! 😞
FYI - My ColPlotPermission collection just has one Column called "Result" (See pic attached)
