A way to compare a text value in a table to a value in a collection

[Jeffclark]

I have two collections. One collection gets the results that matches the sectors, and then the other collection should use the id that returns in the results that come from the matching criteria. However, there is an issue of text, table comparison other. Is there a way to do this?

[Ethan_R · Accepted solution]

Hi @Jeffclark ,

Use the following code from getting diqPeople that matches ID from diq

ClearCollect(
    diqExpertId,
    Filter(
        'dbCDE.DiqPeople',
        ID in diqId.Id
    )
);

Hope this helps