cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Santhosh001
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

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

View solution in original post

2 REPLIES 2
WarrenBelz
Super User
Super User

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

Thanks @WarrenBelz  It's working

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,390)