Answered

Canvas App Collection is Data Type: Table?

(0) Share

Report

Posted on by accepto

I have an OnChange event on a DropDown box where I'm creating a collection as following:

ClearCollect(
collectNearmissUserInfo,
{
Email: Text(cmbCreatedOnBehalfOfColleague.Selected.Mail),
Dept: LookUp(Users, 'User Name' = "xx@xxx.xx").'Department XX'.Department
}
);

I now want to use the "Dept" value (which value is A100) to insert into a LookUp:

LookUp(Departments, Department = collectNearmissUserInfo.Dept).Brand

But it gives me an error saying: "Incompatible types for comparison. These types can't be compared: Text, Table"

What am I missing, pls help 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try

LookUp( Departments, Department = First(collectNearmissUserInfo).Dept, Brand)

Was this reply helpful? Yes No
Verified answer

accepto 17 on at

Like
a
(1)

Report
Copy link

Link copied!

Found the solution:
I needed to write "in" instead of "=" ...
LookUp(Departments, Department in collectNearmissUserInfo.Dept).Brand

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Putting FIrst() around it will also work as it will return the record instead of the entire table, for future ref

Was this reply helpful? Yes No
accepto 17 on at

Like
a
(0)

Report
Copy link

Link copied!

When I try to do this works - but it gives me a warning saying:
Delegation Warning. The "LookUp" part of this formula, might not work correctly on large data sets

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Ah Yes, delegation warnings. If there's ever a chance your datasource will go above 2,000 items then delegable searches are indeed best

Was this reply helpful? Yes No