You’re offline. This is a read only version of the page.
My Question regarding power canvas app
in canvas app i created login page .in login page it will first check email and password from crm entity called dipendenti . If eamil and password is correct it will go to next screen and in next screen as you show below second image you can see there are some field one of them is lookup field .
1.From here check email and password on behalf of that user can login into next page and name field will be store in lookup filed of next screen
Login page check from dipendenti entity
Login page
2. I want to set this look up field pre set .it is possible to take name from where we checking email and password and pre set that name in lookup field
this look value show the name of dipendeti entity
Thankyou in advance
!please help mw with this
I put this code On default but it's not work for me , And my table name is
First one is table name of current screen form And second yellow mark is represent Lookup field logical name
But i want to pre set the lookup value base on our login page which are compare from user id and password from another entity (syncu_dependentie )
After compare email and password it auto set lookup value from which they login
You've put the "LookUp()" in the wrong property of the dropdown.
You've put it in "OnChange()" when it should be in "Default" property.
Also, you must swap "table" and "name" with your table name and your column name to properly retrieve the column's value from your table.
"table" and "name" were merely examples in my sample code as I don't know your table's name and structure.
Yes but in my case all record having their password and email if Someone enter particular record email or password name field be pre set in lookup field or if there is another way to set the name on another screen then please help me with this
Thank you very much for reply #
this code i use to Check login user information, i put this code into an Login button
After check and successfully enter into the next screen i want to pre set the lookup value in lookup value their is name from where email and password is enter , i just want to preset the name of that record which are list in lookup field
This Dipendenti (syncu_dipendenti) records , All Nome(Name) Exist in lookup field
This is one of those record which are i am login through there email and Password and this record name i want to pre set in the lookup field , which are in another screen of canvas app
Thankyou very much for reply ! #Wizy
I tried your code but does not work for me. please understand my scenario and help me with this
Yes, Could you help me
Hi
Do you want to set default value of the look up field based on current logged in user ?
Hello @Beginner_Aman ,
Yes, it is possible.
Inside the "Default" property of your combobox, put the "LookUp()" function to retrieve the name of the person in your table based on the condition where the mail and the password correspond.
Share
Report
All responses (
Answers (LookUp(table; And(Mail=InputMail.Text;Password=InputPassword.Text)).Name
I hope this was helpful to you.
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
