Unanswered

Populate field based on another fields value

(0) Share

Report

Posted on by AmariBarino

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (2)

Report

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

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
AmariBarino 59 on at

Like (0)

Report

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!

Was this reply helpful? Yes No