I created a model driven app with a form that has the fields "Item Code" and "Description" in it. Based on the Item Code selected, I want the description to populate automatically. I have an excel sheet with over 800 values in it. I understand that this is possible through business rules but I can only create 9 different statements within one rule and this would take hours to complete. I wanted to know if there was a way I can map the columns together so that when a user types out an Item Code, it pulls the corresponding description into that field.
Any help is greatly appreciated.
