cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Autopopulate from SharePoint List

Hello,

 

Please refer to the screenshot below. I need the Property Name field to autopopulate when a user inputs the associated number in the FHA Number field. Once a user inputs the FHA Number, a linked SharePoint list (called A-MAP) will pull the property name based on the corresponding FHA Number.  Can anyone assist me with this? I've already linked the SharePoint list, but I cannot figure out how to make the Property Name field autopopulate with the data.  Thank you!

k_cain_0-1610139148062.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

@k_cain 

Your formula is wrong.  Please use the following:

LookUp('A-Map', 'FHA Number'='FHA Number_Input'.Text, 'Property Name')

 

You have an extra paren in yours.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

8 REPLIES 8
Super User II
Super User II

Hi @k_cain ,

Set the Default property of the property name control to:

LookUp('A-MAP','FHA Number'=TextInputYourFHANumb0erControl.Text,'Property Name')

 

Hope it helps !

Super User III
Super User III

@k_cain 

Set the Default property of the Property Name (assuming this is a Text Input control - if not, then set the Text property) to the following:

LookUp(A-Map, 'FHA Number' = Value(yourFHATextInputControlName.Text), 'Property Name')

 

Replace your actual names into the above and you should get what you want.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
Super User III
Super User III

Hi @k_cain ,

Assuming that

  • 'FHA Number' field and 'Property Name' field are both the the list 'A-MAP' and 'FHA Number' is a Text value,  calling your Text Box txtFHANo in the below, the Default of the Property Name box would be 
LookUp(
   'A-MAP',
   'FHA Number' = txtFHANo.Text
).'Property Name'

 

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.

 

I tried that, but I'm getting an error message saying there's an incompatible type.  Any ideas?  Thanks!

k_cain_0-1610145522796.png

 

I tried that, but I'm getting an error message saying there's an incompatible type.  Any ideas?  Thanks!

 

k_cain_0-1610145522796.png

 

Super User III
Super User III

@k_cain 

Is 'FHA Number' defined as a text column or numeric column in your list?

If it is text, then change your formula to:

LookUp('A-Map', 'FHA Number'='FHA Number_Input'.Text, 'Property Name')

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Randy,

 

No luck with that either.  Please see the two screenshots below, which includes a screenshot of the SharePoint list column types from which the inputted FHA Number and Property Name will be pulled.  They are both listed as "Single line of text."

k_cain_0-1610147105002.png

k_cain_1-1610147118997.png

 

 

Super User III
Super User III

@k_cain 

Your formula is wrong.  Please use the following:

LookUp('A-Map', 'FHA Number'='FHA Number_Input'.Text, 'Property Name')

 

You have an extra paren in yours.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (39,121)