If condition inside foreach loop for collection not working

Like (0) Share

Report

Posted on 19 Mar 2024 09:20:33 by shrikantswnt

112

I have 2 collections as shown in below images.

I have applied Foreach loop, inside which I am checking If Condition which is not working. Code is as below

ForAll(
collAdditionalPassenger,
If(CountRows(Filter(collVMSFuture,Title = CPR))=0,
Patch(
'Visitor Details',
Defaults('Visitor Details'),
{ CPR: CPR,
Name:Name,
Organization:Organization,
Mobile: Mobile,
CarPassRequired: If(Lower(CarPass)="false", false, true),
CarID:CarID
}
)
)
);

Categories:

General Questions

Using Apps Using Formulas

Connecting to Data

All responses (3)

Answers (1)

Suggested answer

shrikantswnt 112 on 16 Feb 2025 at 07:17:00

Like (0)

Report

If condition inside foreach loop for collection not working

@BhaskarDhone : Its working. its all because of column name.
shrikantswnt 112 on 19 Mar 2024 at 11:50:49

Like (0)

Report

Re: If condition inside foreach loop for collection not working

Thanks for the reply @BhaskarDhone .
But the behaviour is the same even after changing the code.

If I manually check for value it works fine For ex.
If(CountRows(Filter(collVMSFuture,Title = "777777773"))=0,

but if I use runtime value it is skipping the condition
If(CountRows(Filter(collVMSFuture,Title = collAdditionalPassengerA.CPR))=0,
Verified answer

BhaskarDhone 1,129 Super User 2025 Season 2 on 19 Mar 2024 at 10:33:55

Like (0)

Report
Re: If condition inside foreach loop for collection not working

May be because of same column name system is getting confused
Try this
ForAll( collAdditionalPassenger As PassengerCollection, If(CountRows(Filter(collVMSFuture,Title = PassengerCollection.CPR))=0, Patch( 'Visitor Details', Defaults('Visitor Details'), { CPR: PassengerCollection.CPR, Name:PassengerCollection.Name, Organization:PassengerCollection.Organization, Mobile: PassengerCollection.Mobile, CarPassRequired: If(Lower(PassengerCollection.CarPass)="false", false, true), CarID:PassengerCollection.CarID } ) ) );