How is my dataverse table linked to User table?

(1) Share

Report

Posted on by CU28080333-1

Hi,

I have a dataverse table that has N:N relationship with User table (systemuser). In my dataverse form in a model driven app, I can add existing users from User table using a subgrid and save their information. My question is, how are they joined? I'm trying to get the list of users selected in this subgrid and generate an automated email using Power Automate. After spending so much time, I just could not figure it out. PLEASE HELP! And let me know if you need more information. Thank you!!!!

Categories:

Power Automate Mobile App

I have the same question (0)

All responses (5)

Answers (0)

Sort by

André Arnaud de Cal... 679 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Can you please explain the data model for your custom Dataverse table linked to the User table? What exact details, more than the subgrid, do you have on your model-driven app? What details from your model-driven page do you send to your flow?

Was this reply helpful? Yes No
Suggested answer

Vish WR 3,748 on at

Like
a
(0)

Report
Copy link

Link copied!
@CU28080333-1

Can you share more details?

In the flow

Use “List rows” on your main table record

Expand the N:N relationship column (or use FetchXML)

Retrieve related SystemUser records

Loop through the returned users and collect their email addresses

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
CU28080333-1 7 on at

Like
a
(1)

Report
Copy link

Link copied!

There is no specific lookup column for this subgrid. The only place I see the link of these two tables are in Relationships property of my custom table. Below is the screenshot of the User subgrid in my main form of the custom table. It is set to show related records only, so I know there is a connection between my table and User table, but I cannot identify it. My goal is to get the primary email field value in Power Automate, but cannot find a way to "List rows" in the flow.

Was this reply helpful? Yes No
André Arnaud de Cal... 679 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

You mentioned that you can see a relationship between the tables and that you can't identify a connection. This sounds contradictory to me. Can you please explain it?

I will repeat the question to provide more details. What is triggering the flow, what details are passed to the flow? What actions did you define so far? It is very hard to know what you have done so far and where you are stuck now. Please provide all details, so we know how and where to help you.

Was this reply helpful? Yes No
Suggested answer

Valantis 6,740 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @CU28080333-1,

The N:N relationship between your custom table and the User table works through a hidden intersection table that Dataverse creates automatically. You won't see it as a lookup column on your main table because it's not a lookup it's a separate table storing pairs of IDs linking the two tables together.

To get the related users in Power Automate, you need to query that intersection table directly. Here's how:

1. First find the intersection table name. Go to make.powerapps.com > Tables > your custom table > Relationships. Find the N:N relationship with User and note the Relationship table name. It will look something like cr20b_yourtable_systemuser.
2. In Power Automate, use a List rows action and select that intersection table as the table name. Filter by your main record's ID: cr20b_yourtableid eq 'your-record-guid'
3. This returns all the systemuser IDs linked to your record. Then loop through each row and use another List rows or Get a row action on the systemuser table to retrieve the internalemailaddress field (that's the primary email for system users).
4. Collect those email addresses and use them in your Send email action.

To trigger the flow: if this should run when a record is updated in your main table, use the Dataverse trigger "When a row is added, modified or deleted" on your main table. Your main record's ID will be in the trigger output to use in step 2.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No