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.
