Announcements
Hi!
I have trouble figuring out these nested data connections.
I want to remove each record in "InsuranceSplit" if column "InsuranceTypeSplitId" exists in the table "InsuranceTypes" BUT only where the column "ClientSplitId" is also equal to my variable vClientSplitId.
"InsuranceSplit"
"InsuranceTypes"
Hi @benyie ,
You can do something like this:
ForAll(InsuranceTypes, RemoveIf(InsuranceSplit,InsuranceTypeSplitId = InsuranceTypes[@InsuranceTypeSplitId] && ClientSplitId = vClientSplitId))
_____________________________________________________________________________________Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!
Sorry @Gochix ! I was too quick, this actually didn't work as expected.
Because I first have to filter the table "InsuranceTypes" where the column ClientSplitId equals my vClientSplitId. After that I make the comparison and remove each record in "InsuranceSplit" if column "InsuranceTypeSplitId" exists in the filtered table "InsuranceTypes"
the formula does exactly what you are asking. I’ve checked at my end before posting it and it worked fine. If this doesn’t work for you then could you explain what does the formula do so we can see what to adjust.
@Gochix Oh now I see it worked.
I only read 500 records from database right now.
Since this operation takes several records I couldn't first see that anything happened at all.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 541
WarrenBelz 434 Most Valuable Professional
Valantis 289
