Standard Macro flow - no values populated in drop down list

[AliMc7]

Hi everyone, 

I'm running through this tutorial on setting up a standard macro with a drop down option for users.

The macro itself runs fine, but there are currently no list values from the "company name" field populated in list properties and I just can't work out why... (see attached .png). 

I'd like to test this approach using some of our local data where we need to look at specific faculties etc. for reporting, but need the drop down option to work. I've checked joins etc. and just can't see why the values aren't feeding in. 

Appreciate any advice, very new to this!

Best

Ali

[JosephSerpis · Accepted solution]

Hi @AliMc7 as per your screenshot the drop down is set to manual set values therefore you have to enter the values you want in the dropdown tool.

E.G.

Company A:A

Company B:B

[danilang · Accepted solution]

Hi @AliMc7 

If you want to populate with values from a database or file, change the List Values option to External source and configure the source as if it was an Input tool.  The items from the source need to have a NAME and a VALUE field.  NAME gets displayed in drop down and VALUE is returned by the drop down. A typical example would have NAME=Company name and VALUE=CompanyID.  NAME and VALUE can be the same.   

Dan

[AliMc7]

Many thanks both - I've misinterpreted the part of the tutorial which say "Select the ‘List Values’ and manually set values. This step only creates the user interface so we still need to create an action." and just assumed that because the Company Name field is selected via the filter tool, this would somehow auto-populate the list values. Assigning names/values from source has worked. 

Thanks again.