Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Model Driven App - Populate multiple text boxes using lookup field



I'm building a Model-Driven App for a customer and have a question. So I have a form with a section that has several fields: the Position ID is a lookup field that is connected to another table, the other fields are only text boxes (greyed out):




What I want: when I select a Position ID value via the lookup field, the other text boxes should be populated with the data from the data record for which the Position ID in my position ID table is e.g. '2'.

Is there a way to accomlish this? Since this is very dynamic, I don't want to use a flow. And a business rule is too unflexible and inconvenient.



Here is a way with a business rule that does not work:




So when a specific ID is selected by the user, the rule should not set the Position Name EN value to 19734, but to Technician Student. And this doesn't work, it only selects the ID every time.









Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,696)