Set var using lookup to a collection

(0) Share

Report

Posted on by drossi90

188

Hi there,

I have some OnStart code to try set some variables.

varUserEmail sets OK. But I cannot set varUserTraderID, it just remains empty.

I've tried a few different ways:

Set(varUserTraderID,
LookUp(
colUserDetails,AsTraderEmail=varUserEmail).EmailTraderID)

Main OnStart code

Set(varUserEmail, User().Email); 

ClearCollect(colUserDetails,

 {AsTraderEmail:"info@xxx.ie",EmailTraderID:"258"},
 {AsTraderEmail:"aquaxxx@gmail.com",EmailTraderID:"202"},
 {AsTraderEmail:"dxxx@xxx.ie",EmailTraderID:"218"}
 );


Set(varUserTraderID,
LookUp(
 colUserDetails,"AsTraderEmail"="User().Email","EmailTraderID"))

;
InstallHub

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (2)

Sort by

drossi90 188 on at

Like
a
(0)

Report
Copy link

Link copied!

hey any ideas?

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @drossi90

Please remove the double quotes around the parameters in the LookUp function.

Set(varUserEmail, User().Email); ClearCollect(colUserDetails, {AsTraderEmail:"info@xxx.ie",EmailTraderID:"258"}, {AsTraderEmail:"aquaxxx@gmail.com",EmailTraderID:"202"}, {AsTraderEmail:"dxxx@xxx.ie",EmailTraderID:"218"} ); Set(varUserTraderID, LookUp( colUserDetails,AsTraderEmail=User().Email,EmailTraderID))

Best Regards,

Levi

Was this reply helpful? Yes No
drossi90 188 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @v-liwei-msft

I've previously tried this but this doesn't work.

My assumption is that the issue is to do with the User().Email function as if I replace this with just a text string "dxxx@xxx.ie", the varUserTraderID is populated correctly with 218.

There must be something where the User().Email doesn't match a string of the same email.

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @drossi90

For testing, you can add a Lable to see if User().Email is equal to the email in the collection.

OR

Best Regards,

Levi

Was this reply helpful? Yes No
drossi90 188 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your efforts here @v-liwei-msft , I really appreciate it

I've tried that also but with no luck, the email var updates but not the TraderID var.

And yes, User().email is equal to the email in the collection as you can see above.

Was this reply helpful? Yes No
drossi90 188 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry typo on the first screengrab there. I was playing around with column names and can confirm I have:

Set(varUserTraderID, Text(LookUp( colUserDetails,User().Email=AsTraderEmail,EmailTraderID)))

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @drossi90

You can try the second method I gave you to see if Lable returns a value.

Best Regards,

Levi

Was this reply helpful? Yes No
drossi90 188 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @v-liwei-msft

indeed it does

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @drossi90

According to the screenshot you provided, User().Email returns Drossi.
In your collection, I found that the field you want to query is drossi.
I think the reason LookUp doesn't return a value is because of case differences.

Best Regards,

Levi

Was this reply helpful? Yes No
Verified answer

drossi90 188 on at

Like
a
(0)

Report
Copy link

Link copied!

No way! it's case sensitive? I didn't realise that!

Apologies. Thanks for all your help in troubleshooting. I spent far too much time over that!

It works! Thanks

Was this reply helpful? Yes No