How to backlink columns values in related tables through lookup columns?

(0) Share

Report

Posted on by Zhenya

123

Hello, I am trying figure out if there OOB method, and if its possible to "connect" 2 related tables.

For example I have custom SIM cards Table (Serialized item ) with contact lookup column and in Contact table with SIM lookup filed is added. If I add (assign) SIM though lookup to Contact, I need update (link) Contact lookup value in SIM table. Currently I am doing through power automate flow but need have similar scenario for various relationships between few tables and maintenance would became an issue.

Is there way to update related fields values natively without running automated flows?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (1)

Report

if I understood correctly you have two 1:N relationship between SIM and Contact (so inside SIM you have a Contact lookup and inside Contact you have a SIM lookup). You should be able to update it using a classic workflow, otherwise a plugin (code)

Was this reply helpful? Yes No
Zhenya 123 on at

Like (0)

Report

Ok, thank you, wasn't sure, since MS recommend to replace classics flows with Power Automate, but will try then with classic. Power automate cloud flows works but it must lookup though another table, check if value returned, can fail, etc.
And it doesn't work 2 ways, as will trigger infinite loop, etc. If I assign to Contact I have it triggered and update SIM record. If I use SIM firm and assign Contact, it will trigger another flow run once SIMs field modified in Contact. Then conditions to cancel, many runs, maintenance to keep all

Thought maybe something possible through relationship settings/connections. In my case SIM used in Shipment, Orders, etc, Sales,
Ideally, use case is once user opens SIM records he can see which Contact it was given, when was sold (Sales), shipped (Shipment) etc. And same from other tables.

Was this reply helpful? Yes No
Verified answer

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

your case will be usually solved by a 1:1 relationship that is not available in Dataverse.

Both in your flow or classic workflow you will need to add check conditions (check if the field is empty or the field has a different value from the one you want to set) otherwise you will have an infinite loop.

Afaik you can't manage your scenario with just relationship settings

Was this reply helpful? Yes No