Populate field based on another fields value

[AmariBarino]

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. 

[dpoggemann · Accepted solution]

Hi @AmariBarino ,

One thought here is to create another table for your Item Codes and add a lookup to this table to the Item Code.  You could then add a Quick View form from the Item Code table to display the Item Code details right on the form after they select.  This could include the Description, etc. if you had more fields on the Item Code.  Also you would have the advantage if the Description changes it will always show the current value.

https://docs.microsoft.com/en-us/power-apps/maker/model-driven-apps/quick-view-control-properties-le... 

[rampprakash]

Hello @AmariBarino 

There are Multiple Suggestion available,.

1. As mentioned by @dpoggemann 

2. Create A Microsoft flow to trigger only on Item code field then retrieve the value and update the Description.

3. If you want real time, trigger JAVASCRIPT, on ONCHANGE event 

Ping me private if you need any help.

[AmariBarino]

This worked! Thank you so much. I modified my quick view form and the request details form so that the description field looks like its one of the other fields. Very useful tip!