I have a number of photos that all reference the same item in another table.
I would like to select one of those photos to assign as the items thumbnail image.
I was able to do this in the Items form as a Enum column of a base type of Thumbnail
I then put in this expression in the “Valid if” formula
SELECT(Photos[Image], [Collection_ID]=[_THISROW].[ID], TRUE)
It works great but if I go back into the Items form to edit, the Enum for the Thumbnail shows me a “This Entry Is Invalid” error.
It is still working but I’d like to know if maybe there was a better way for me to accomplish this or fiix this valid error.