Solved: Trying to filter a collection by GUID and it always shows all results

I have an app, where I am trying to link comments to a order record by writing the GUID from the order into a field on the comments. But I cannot filter only the comments associated to each record.

I can successfully collect (ThisItem) the GUID in a Gallery and add it to a variable

Set(gvID, ThisItem.'Orders Master');

This works! I can see the GUID as a variable successfully by adding a text field with gvID in the Text field

Then I clear collect a collection of Comments, where I grab only the columns that I want to see. The crf0b_masterid is a GUID that has the GUID from the Master Table (to link to).

ClearCollect(colComments, ShowColumns('Comments', "crf0b_comment", "createdby", "crf0b_masterid", "createdon" ));

This brings back every items with the crf0b_masterid column being populated with the GUID of the Master Record.

But...when I filter the collection to only see the comments associated to that gvID

Filter(colObservations, gvID = crf0b_masterid );

It shows all records, no filtering is being done.

I get no errors on the syntax. It looks good to me. Do you see anything that I am missing?

Categories:

Using Apps Using Formulas