Forum Discussion
Lookup Column for Multiple Values
How would I structure lists and lookups to allow for looking up an item that would have multiple values. Use case: A list has the following columns: "Crop" and "Variety" User creates new item. U...
Hi Dan Barnett this can be done with a PowerApps form inside SharePoint where Microsoft in the last few days have released an easier way to do cascading dropdowns: https://powerapps.microsoft.com/en-us/blog/configure-easy-dependent-drop-downs-in-powerapps/
A very basic example I've just done is in the image below. So for example when Peppers are selected in the crop dropdown only the variety of peppers are available for selection in the varieties dropdown. If you need a step-by-step for how I did this post a message here or send me a PM and I'll write it up.
Rob
Los Gallardos