Lookup to populate another text box

(0) Share

Report

Posted on by LeeJBS

Hi All, Sorry im a bit stumped and new to powerapps.

I have 2 sharepoint lists

Contacts
- Name
- Email
- PersonalNumber
MobileServices
- Name
- AccountNumber
- Simcard
- NewNumber
- SerialNumber

In powerapps i have a screen that has a name field That comes from the sharepoint list contacts. When its updated i need simcard number text box to be updated with the simcard number IF its in the mobile services sharepoint list otherwise leave blank for a new simcard number to be provisioned.

Would the "Onchange" property on the name textbox be the right spot for to initiate a lookup to then populate the simcard text box?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, OnChange would look something like this:

Set(SimCardValue,LookUp(MobileServices,Name=LookUp(Contacts,Name=TextInput1.Text,Name),Simcard))

and then on the SimCard textbox, set the default value to this:

If(SimCardValue=false,Blank(),SimCardValue)
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LeeJBS ,

Just to correct his answer.

on the SimCard textbox, set the default value to this:

If(IsBlank(SimCardValue),Blank(),SimCardValue)

Best regards,