Set global variable based on an item in a list with conditon

(0) Share

Report

Posted on by skong

142

I have a list with two columns as the following specification

requesters : email (text) ,

account_no(text) - may have multiple values separated by a comma,

for example :

email account_no

joe@abc.com 121323,12022

John@abc.com 123231

Jane@abc.com 10222,102231

In the onStart I am using the following formula to extract the user_account_no.

If (User().Email in Requesters.email, Set(user_account_no, Requesters.account_no)); doesn't work, I know I may have to use lookup or filter to find the matching item. I add a lookup function like this. If (User().Email in Requesters.Title,
Set(user_account_no, LookUp(Requesters, Title=User().Email, account_no) )
); still doesn't work.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

Try giving your If statement a second argument:

If(
User().Email in Requesters.Title,
Set(user_account_no, LookUp(Requesters, Title = User().Email, account_no),
Set(user_account_no, "Doesn'tExist")
)

Was this reply helpful? Yes No
skong 142 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Zmorek,
I just try it doesn't work.

Thanks

SK

Was this reply helpful? Yes No
zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

What error message does it give? Can you add a screen shot?

Was this reply helpful? Yes No
skong 142 on at

Like
a
(0)

Report
Copy link

Link copied!

When I run the onStart it show there are warning messages. The warning message were delegation issues.

Was this reply helpful? Yes No
Verified answer

zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

Delegation issues are from the LookUp portion of your formula, the = User().Email isn't delegable.

Try something like:

Set(varUserEmail, User().Email);
If(
varUserEmail in Requesters.Title,
Set(varUserAcctNumber, LookUp(Requesters, Title = varUser, account_no)
)

Was this reply helpful? Yes No
skong 142 on at

Like
a
(0)

Report
Copy link

Link copied!

It works. Thanks a lot. So the delegation warning matter.

Was this reply helpful? Yes No