Autopopulate lookup column based on another lookup column

(0) Share

Report

Posted on by md7

232

Hi all,

In my dataverse I have Organisations, applications and buildings.

One organisation can have many applications. One application can have many buildings.

On my building table i have two columns that are lookups looking at applications and organisations.

When creating a new building row, how can i make the organisation lookup field automatically populate based on the application that is linked to it?

I think it is possible to do with relationships but I'm not sure which relationship i have to change between each of the tables.

I'm using a model driven app to present my data.

Thanks.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

steeevid 323 Super User 2024 Season 1 on at

Like (0)

Report

I did this with power automate.

Cons: it takes 1min to populate 10 items

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi @MD7 ,

There are couple of approach:
1) You can do this using JavaScript when creating building on the Form. (Its faster and quick on the Form)
2) You can use Plugins when creating and saving the Building. (This is still better considering if you Import Records using Excel, CSV or Power Automate)
3) Power Automate Flows are async actions that won't notify the Users in Real-Time. Also, if connection breaks then your process might break but still a decent method.
4) I'm not sure with this one, but you can use Field Mapping that can pass the value from 1 table to another as long as it is linked or created from Application form itself.

Hope this helps

Was this reply helpful? Yes No
md7 232 on at

Like (0)

Report

Thanks for all of your answers. I'm not too sure on how to do the javascript or what plugsin to use so have opted for the power automate flow which @Stevieed mentioned. It seems to work fine, albeit a bit slow.

Was this reply helpful? Yes No
md7 232 on at

Like (0)

Report

@Ethan_R @Stevieed
Is it possible to filter the list rows action to speed things up?

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi @MD7 ,

You can do the following to make it little faster:
1. Use appropriate fetchXML (proper connection of tables) with only those attributes that you want. (Reason is, collecting many unwanted fields might result in delay for get entire row)
2. If you don't need additional column then you list all necessary fields in 'Select Columns' parameter on Trigger or 'Get row by ID' if used.

Hope this improves the execution up to some extent.

Was this reply helpful? Yes No
steeevid 323 Super User 2024 Season 1 on at

Like (0)

Report

Just use filter row in the list row action

Was this reply helpful? Yes No
md7 232 on at

Like (0)

Report

For some reason it is picking the wrong organisation.
Here's my building:

Here is my application.

The building organisation should be the same as the application project owner.
I think i need to use the filter rows field in the flow but unsure what to put.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi @MD7 ,

How is the FetchXML configured?
I think Project Owner also has other records and the last record's Organization is been set in your Buildings record.
Check the Flow history, where it has captured total number of records from 'Applications' table.

Let me know

Was this reply helpful? Yes No