cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tianaranjo Continued Contributor
Continued Contributor

Cascading RemoveIf

I have 3 collections:

colSelectedOrder, {ID, Result} - 

  • ex: 1, inputWY (result = name of input field selected)

colValue, {ID, Result} - 

  • ex: 1, 2020 (result = value typed into text box of selected field (above))

colFields - (Joins two collections on the ID)

ClearCollect(

    colFields,

          AddColumns(colValue, "Input Field",
    LookUp(colSelectOrder, ID = coltNumValue[@ID], Result)))

  •  ex: 1, 2020, inputWY

Is it possible to cascade the RemoveIf so the records are deleted from all collections?

 Thank - in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
mr-dang Community Champion
Community Champion

Re: Cascading RemoveIf

Hi @tianaranjo,

You've got 3 collections which all share the same ID, and you want to remove the same record from all 3 of them.

 

This can be done by identifying the ID to be removed, then using remove statements for each collection.

 

 

Set(removeID,ThisItem.ID);
Remove(colSelectedOrder,Filter(colSelectedOrder,ID=removeID));
Remove(colValue,Filter(colValue,ID=removeID));
Remove(colFields,Filter(colFields,ID=removeID))

This should work out assuming that the IDs are unique (there's not more than one in each table).

 

Let me know if that works out with a thumbs up.

 

Mr. Dang

_______

Microsoft Employee
@8bitclassroom

View solution in original post

2 REPLIES 2
mr-dang Community Champion
Community Champion

Re: Cascading RemoveIf

Hi @tianaranjo,

You've got 3 collections which all share the same ID, and you want to remove the same record from all 3 of them.

 

This can be done by identifying the ID to be removed, then using remove statements for each collection.

 

 

Set(removeID,ThisItem.ID);
Remove(colSelectedOrder,Filter(colSelectedOrder,ID=removeID));
Remove(colValue,Filter(colValue,ID=removeID));
Remove(colFields,Filter(colFields,ID=removeID))

This should work out assuming that the IDs are unique (there's not more than one in each table).

 

Let me know if that works out with a thumbs up.

 

Mr. Dang

_______

Microsoft Employee
@8bitclassroom

View solution in original post

tianaranjo Continued Contributor
Continued Contributor

Re: Cascading RemoveIf

@mr-dang Thanks for the reply - I found another work around utilizing only one collection.  But I think this will come in handy for future use.

 

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (9,301)