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.
Solved! Go to Solution.
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?
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?
The Lookup() looks correct. Where is the Lookup() set on the 'Delivery Address' control?
Have you tried adding it to the Default property of the Text Inout Control?
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?
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
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand