Hi,
You can certainly use a flow, but I am perplexed, can you please share exactly what the UI says when you try to create the relationship? It sounds like a very simple 1:M, because yes, you should just create the 1:M relationship and get the status directly from Teams. I wouldn't do any of this work below, but I'd need to know why you cannot create it to help with that part. So instead I will answer (as well)
I would like to make a suggestion:
A) I can answer as you asked (for your pseudo design)
B) You can also do a Trigger on the Teams table. When the Status changes, it triggers and you update the Members table. Now you may need to do A) first to "catch up and then B) teh rest of the time
Option A:
Trigger: Reoccurring
Step 1: Use List Rows and set the filter of columns to the TeamId and TeamStatus columns (no sense pulling back the rest)
Step 2: Apply to Each, with an INPUT of the Dynamic Property called "value" from the Step 1 List action
Step 3. Now you said you want to Update the Team status, so you need a List Rows, against the Members table, and filter on the TeamId that you get from the Apply to Each (value) property
It seems like you will get 1:M rows back.
Step 4: Add an Update a row Action (dataverse)
Use the Row Id from the second Apply to Each(for members)
and use the Status from the Teams (Apply to Each)
Option B:
Is exactly like A excely that instead of you doing a List Rows and an Apply to each YOU TAKE THOSE OUT and Step 3 above becomes Step 1, since you have the TeamId and TeamStatus from the Trigger properties.
Step 4 (option A) is now Step 2
And done
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
