Pass values from parent lookups to child forms

(2) Share

Report

Posted on by Arjan

Maybe this is a very novice question but i am struggeling to understand how i can manage the following.

Lets say i have a table setup that looks like this:

Country
State
City

I have created the following relations between the tables:

Country
State -> Country
City-> State
City - Country

When I am in a form for states, I would like to add some cities from a subgrid. When I create them, the state is automatically filled, but the country is not. How can I use the lookup field I created in State → Country to automatically fill the country when adding a city?

I hope I have described it correctly.

Kind regards,

Arjan

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

Arjan 41 on at

Like (0)

Report

Pass values from parent lookups to child forms

I ended up with setting up field mappings grabbing the values from the parent entity and copy that to the child entity, business rules cannot be used to solve this.
Suggested answer

SpongYe 5,559 Super User 2025 Season 1 on at

Like (0)

Report

Pass values from parent lookups to child forms

Hi @Arjan,

You can achieve this by using Business Rules.

Go check it out https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-create-business-rule

You can create a business rule to set the country field based on the state field.
Set the condition to check if the state field contains data, and then set the country field using the related state record.

Otherwise you can achieve this by using JavaScript Approach.

Hope this helps.