Unanswered

Variable is not working as expected

(0) Share

Report

Posted on by powertwo123

With({userrecord1:LookUp(owner,Title=TextInput1.Text And Password=TextInput1_1.Text)},Switch(userrecord1.Role.Value,"Admin",Navigate(Wattala),Set(varuser,userrecord1.Title)))

Please ignore the commas and parenth.. My set variable is not working.It gets the var user( Variable name but not the value from sharepoint). Kindly help to recorrect.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @powertwo123,

You write this With() formula for the OnSelect property of Button2_1?

Could you please tell me that if you userrecord1.Role.Value returns Admin or not?

Based on your formula, wether the varuser is blank or not depends on if userrecord1.Role.Value returns Admin.

If it does return Admin, then, your varuser does return blank because the Switch() statement only process the Navigate() function.

Was this reply helpful? Yes No
WarrenBelz 154,393 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @powertwo123 ,

It is because you have it inside a Switch statement and it the first part works, it will never run. I am not totally clear on you model, but I think you need something like this.

If( LookUp( owner, Title = TextInput1.Text And Password=TextInput1_1.Text ).Role.Value = "Admin", Navigate(Wattala) ); Set( varuser, TextInput1.Text )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No