Unanswered

Can't figure out why I am getting a comparison error.

(0) Share

Report

Posted on by ED-23102058-0

I am a new Power Apps user with a background in SQL. I am trying to basically join 3 tables together but have them filtered before hand, and I cant figure out why I am getting an error for incompatible types for comparison. My tables have more than 2k records so I need the filter.

I am referring to them like:

ClearCollect(

Info,

AddColumns(

Filter(Products, ItemId = 6789),

ProductDetails,

LookUp(

DeliverySchedule,
ItemId = Products[@ItemId]

)

Error would be saying can't compare a number and a table.
If I take away the filter() it is no longer an issue 

The sql statment would be something like:
select * from table a

join table b on a.id = b.id

join table c on c.id = b.id

where a.Id = ******

If you know a better way to join 3 tables together in a specific order (table 1, table 2, table 3) so table 1 is the main table and table 2 joins to table 1, then table 3 joins to table 2.

Categories:

Using Apps Using Formulas

All responses (3)

Answers (0)

Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report
Can't figure out why I am getting a comparison error.

Hi ED-23102058-0,

Can you try using the following please:

ClearCollect( Info, AddColumns( Filter(Products, ItemId = 6789), "ProductDetails", LookUp( DeliverySchedule, ItemId = Products[@ItemId], "columnName" ), "ThirdColumnName", LookUp(ThirdTable, filterColumn = 6789, "columnName") ) )

Hope this helps.

Kind regards,
Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!
Suggested answer

ronaldwalcott 3,587 on at

Like (0)

Report

Can't figure out why I am getting a comparison error.

Doesn't your Lookup return a record not a value? Also, not sure why you are comparing ItemId when you have already established its value.

Specify the column which you want to return in your Lookup and double check that you actually want to compare ItemId.
Suggested answer

SudeepGhatakNZ 14,303 Most Valuable Professional on at

Like (0)

Report

Can't figure out why I am getting a comparison error.

Provided that ItemId exists in both ProductDetails and DeliverySchedule tables, try this formula

ClearCollect(
Info,
AddColumns(
Filter(Products, ItemId = 6789),
"ProductDetailInfo",
LookUp(ProductDetails, ItemId = ItemId),
"DeliveryScheduleInfo",
LookUp(DeliverySchedule, ItemId = ItemId)
)
)