cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AmariBarino
Frequent Visitor

Populate field based on another fields value

Dynamics Forum Snip.png

 

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
dpoggemann
Super User
Super User

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... 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

View solution in original post

3 REPLIES 3
dpoggemann
Super User
Super User

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... 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
rampprakash
Super User
Super User

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.

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! 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (3,565)