Announcements
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!
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 !
@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.
Assuming that
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!
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')
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."
Your formula is wrong. Please use the following:
You have an extra paren in yours.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 483
WarrenBelz 399 Most Valuable Professional
11manish 327
