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!
Solved! Go to Solution.
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.
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 !
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.
Hi @k_cain ,
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!
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:
LookUp('A-Map', 'FHA Number'='FHA Number_Input'.Text, 'Property Name')
You have an extra paren in yours.
User | Count |
---|---|
236 | |
113 | |
94 | |
59 | |
31 |
User | Count |
---|---|
286 | |
132 | |
106 | |
63 | |
57 |