Autopopulate from SharePoint List

[k_cain]

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!

[gabibalaban]

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 !

[RandyHayes]

@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.

[WarrenBelz]

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.

[k_cain]

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

[k_cain]

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

[RandyHayes]

@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')

[k_cain]

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."

[RandyHayes · Accepted solution]

@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.