You’re offline. This is a read only version of the page.
111
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?
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
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.
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)
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (
