add column from related many*many table

(0) Share

Report

Posted on by nick9one1

334

I cant quite get this to work..

I have two tables that have a many to many relationship. I'm trying to clearcollect and create a string of names from the second table..

the second table 'Users' is the dataverse systemusers table.

e.g.

ClearCollect(
    colMetricSummary,
    AddColumns(
        ELT_Metrics,

        AssignedUsers,

        Concat(ThisItem.Users, 'Full Name', ", ")
    )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

11manish 847 on at

Like (0)

Report
Copy link

Link copied!

In Dataverse, you cannot add custom columns directly to a native Many-to-Many (N:N) relationship table because it is an internal "intersect" table managed by the system. This internal table only stores the unique IDs (GUIDs) needed to link records.

If you need to store additional data—such as a "Date Joined" or "Status"—associated with that relationship, you must use a Manual Many-to-Many relationship instead

try to follow :

https://www.youtube.com/watch?v=jIJ8mfQRr0M

Was this reply helpful? Yes No