Building a form to add data to an existing sharepoint list entry

[rsparks]

I have a list with 4 columns:

The form I've built has 2 dropdowns used to filter the Club/Service based on the Business Unit:

There are for example 100 clubs, and each club is in a different location. I want the Delivery Address field to lookup the 'Address' column based on the Business Unit and Club/Service. (Sorry that the field names don't line up with the columns).

The formula I'm using is:

LookUp('Manager List Practice', 'Business Unit' = Dropdown1.Selected.Text && 'Club/Service' = Dropdown2.Selected.'Club / Service','Address')

The first dropdown is just using text values I've inserted rather than pulling from the list. But the second dropdown is using the real values from the list. 

[Jeff_Thorpe]

What is the error message and when you click into the formula where is the red a squiggly line? Also is 'Address' just a plain text field?

[rsparks]

The error was from an invisible field that copies the data inputted into the address field (fixed now).

Yes Address is just a plain text field. Does it need to be expressed as "Address", 'Address' or Address?

[Jeff_Thorpe]

The Lookup() looks correct. Where is the Lookup() set on the 'Delivery Address' control?

[rsparks]

Lookup() is set on a text input, so that after it pulls the data the user can change the address if needed

[Jeff_Thorpe]

Have you tried adding it to the Default property of the Text Inout Control?

[rsparks]

Yes the formula is already set as the default property. For some reason when I begin typing Business Unit, Club/Service, Service Email Address or Coordinator/Branch Manager it automatically recommends the text with ' ' on either end. But when I begin typing Address it recommends Address without any quotations. 

Is this indicative of anything?

[v-siky-msft]

Hi @rsparks ,

After you set your formulas to Default property,  is there any issue that I can help with?

I have made a test on my side, and it works well.

By the way, single quotes are required when referencing the value of an object, such as a field or table, in which the name of the object contains a space.

For more information, please refer to this blog:  Display names enter Preview for Canvas apps

Best regards,

Sik

[rsparks · Accepted solution]

I have fixed the issue. The column name was actually "Club / Service". I didn't notice the spaces.