A very handy way to assist your Users in filling out forms is to autofill labels and TextInput fields for the City and State based on the user entering the Zip Code and then using the Lookup() function to pull in the City and State from a Lookup table.  This eliminates spelling errors and saves clerical personnel time as well since they only need to enter the Zip Code for any address. The technique involves bringing in the City, State and Zip Code data with the Excel Static Data connector.  This method also avoids delegation issues since Static Data is not affected by them.  A collection of >42,000 items can be created in seconds. You're putting me on!

This blog post is part of a series called AMFTF (a message from the field) containing short blog posts about a best practice, a functionality, a how-to and/or something just worth writing a blog post about  Todays topic is about using a "Single line of text" column type instead of a "Lookup" column type in SharePoint Online.