Incompatible type of comparison. These types can't be compared; Text,Records

[Santhosh001]

Hi !

I have two table For eg)Table1, Table2

Table1 have column ID and Name

Table2 have 3 column ID, Name, score-----Table 2 ID is a lookup column from table1

 Table1                              Table 2

ID    NAME                 ID    NAME      SCORE

1     AAA                     1     AAA         50

2     BBB                      1     CCC         60

                                   2     BBB          70

                                   3     DDD         80

When I click ID 1 I have to have filtered ID on Table 2 like

Table2

ID    NAME   SCORE

1      AAA      50

1      CCC      60 

For that I write a filter formula

Filter(Table2, ID=Gallery1.Selected.ID)

Table 2 ID is a lookup column so, I get a error of

Incompatible type of comparison. These types can't be compared; Text, Records

How to overcome this issue

[WarrenBelz · Accepted solution]

Hi @Santhosh001 ,

Try this

Filter(
   Table2, 
   ID.Value = Gallery1.Selected.ID
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Santhosh001]

Thanks @WarrenBelz  It's working