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)

zmorek 3,272 on at

Like (0)

Report

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 (0)

Report

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

Thanks

SK

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

Like (0)

Report

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

Was this reply helpful? Yes No
skong 142 on at

Like (0)

Report

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 (0)

Report

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 (0)

Report

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

Was this reply helpful? Yes No