Skip to main content
Community site session details

Community site session details

Session Id : 1k//iFWROh8W4zJgK/iwzm
Power Apps - Microsoft Dataverse
Unanswered

Unrelate all values from a record and relate others

Like (0) ShareShare
ReportReport
Posted on 9 Aug 2023 13:33:45 by

I am trying to Unrelate all the values from a combobox and then relate the values from a different combobox. Both combobox reference my Users table from another table (gblExistingCase.Users).

 

I have tried making a collection from the selected items and then unrelating the items

 

 

 

ClearCollect(colPeopleReportedTo_EC_NU,cmbPeopleReportedTo_EC_NDUC.SelectedItems);
ForAll(colPeopleReportedTo_EC_NU,Unrelate(gblExistingCase.Users,ThisRecord));

 

 

 

I receive the following warning "Value must be a data entity record"

 

Nontheless, when I relate the other combobox with the same structure I receive no warning and the relation is made. Namely:

 

 

 

ClearCollect(colPeopleReportedTo_NC_NU,cmbPeopleReportedTo_NC_NDUC.SelectedItems);
ForAll(colPeopleReportedTo_NC_NU,Relate(gblExistingCase.Users,ThisRecord));

 

 

 

I do not understand why when I relate there is no problem, if at the end both structures are identical.

At the end what I want to do is to unrelate all the values from "gblExistingCase.Users" and then relate the updated Users, regardless if some users are already related or not.

Any help to solve my issue is appreciated, I am not sure where the error is.

Categories:
  • RMCoder Profile Picture
    219 on 10 Aug 2023 at 00:09:32
    Re: Unrelate all values from a record and relate others

    I would double check that your second combo box  is referencing the entire table and not just a single column in that table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete