Hi,
I was trying to solve to search lookup column in gallery, it broke the navigation.
So to filter I added a ComboBox, SearchDesktopReviews
Items: AddColumns('TABLE',"DeskTextCol",Text('Audit_x0020_ID'.Value))
Same for the DesktopGallery
Items: Search(AddColumns('TABLE',"DeskTextCol",Text('Audit_x0020_ID'.Value)),SearchDesktopReviews.Text, "DeskTextCol")
Audit_x0020_ID is a lookup column. Thus, until I add another column, I cannot do search in it.
Then "AddColumns" I am getting error on the form Screen
Form
Items: DesktopGallery.selected
Error: Invalid formula. Expected a value compatible with 'DataSource'.
I couldn't figure out how to transfer changed gallery table to form.
Any suggestions,advice?
Thanks,
