So, this has me completely confused:
I have a Gallery inside a Component.
The Component has an "Items" Property that is set to:
Table(
{ID:"Comment_1", Comment: "SampleText", ParentComments: "", Created: Today(), 'Created By':{DisplayName:"Sample Author",Mail:"sample@email.com"}},
{ID:"Comment_2", Comment: "Sample Text 2", ParentComments: "", Created: Today(), 'Created By':{DisplayName:"Sample Author",Mail:"sample@email.com"}}
)
There is a Gallery inside the Component, with the Gallery.Items Property set to:
SortByColumns(
AddColumns(
AddColumns(Parent.Items
,"_id",Text(ID)
,"ParentIDHash",If(IsBlank(ParentComments),ID&"",ParentComments&"_"&ID)
)
,"SortOrder",If(
Find("_",ParentIDHash)=Blank(),
Value(ParentIDHash),
Left(ParentIDHash,Value(Find("_",ParentIDHash)-1))
)
)
,"SortOrder","ParentIDHash"
)
The Gallery.Items is throwing a Runtime Error: "The value 'Comment' cannot be converted to a Number"
As you can see, the formula above does NOT refer to the 'Comment' column at all!
The same error is thrown if I add the component into an App.
I have tried removing the Gallery.Items Formula and re-entering.
I have tried removing the Component.Items formula and re-entering.
I have tried closing the App/Component Library and reopening.
No joy.
Anyone have any Ideas?
