You’re offline. This is a read only version of the page.
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.
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!
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.
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.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (