Power Platform Community Forum Thread Details

Hey, is this even possible?

Using Dataverse, Table1 and Table2, have a many-to-many relationship. Table2 is the systemuser datasource.

Adding this to the gallery: AddColumns('Course schedule',"UserTable", systemuser)

This gives no errors. So I add a textlabel in the gallery and it's all blank:

Concat(ThisItem.UserTable.firstname, " ")

Without the addColumns I can also make a concat for the related table but it also works without errors but shows up blank:

Text(Concat(ThisItem.'Användare (key_Courseschedule_SystemUser_SystemUser)'.fullname, ", "))

This actually shows the correct amount of related users, the AddColumns pulled in many more.

Showing the related data in a gallery works too:

Gallery1.Selected.'SystemUser (key_Courseschedule_SystemUser_SystemUser)'

Ideas?

Categories:

AddColumns for Many-to-many related table?