Dynamically?

Question

When I choose a Value from a drop-down list in Team Forms can that value populate the value its connected with dynamically example I choose business name and it populate the address

Anthony Phan · Accepted Answer

Hi Sky,

Yes, the easiest way to do this is to use SharePoint data sources. First set up a SharePoint list or Excel file with a name and address column. Then set up a dropdown list with the data from the excel/list by following the data sources tutorial.

Now if I understand your question properly you want to automatically populate a text field with the address column when a specific name is selected in the drop-down menu. To do this we can use a calculated value using the steps below:

Drag-and-drop a text field into your form to display the address
In the data tab of the text field settings go to the calculated value property and enter the following JavaScript expression. Note that you will need to adapt the JavaScript to fit your specific form and column names.
```
value = data.contact.Address
```

Here is an example of the final result.

Team Forms calculated value form a drop-down menu

Calculated values can be a little complicated and the expression needs to be tailored for you specific form and scenario, for this reason I recommend watching our YouTube video on this topic which dives into this feature in more detail :)

Join the Team Forms community

Dynamically?