Unanswered

In Canvas App How to pre set lookup value

(0) Share

Report

Posted on by Beginner Aman

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

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

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

WiZey 3,023 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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.

LookUp(table; And(Mail=InputMail.Text;Password=InputPassword.Text)).Name

I hope this was helpful to you.
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
Do you want to set default value of the look up field based on current logged in user ?
Beginner Aman 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, Could you help me
Beginner Aman 13 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Beginner Aman 13 on at

Like
a
(0)

Report
Copy link

Link copied!

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 #
NandiniBhagya20
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Beginner Aman 13 on at

Like
a
(0)

Report
Copy link

Link copied!

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