Loop through column values in a record

[Sujimon]

Hi,

I am loading a record into collection using below code. I want to loop through the columns and perform some action if column value is "No". 

Set(varUser, User().Email);

ClearCollect(myCollection,LookUp(tblStaff,Email = varUser));

Thanks

Suji

[iAm_ManCat · Accepted solution]

Hi, you can't loop through column values, you have to specify a check for each of the columns

like:

ForAll(myCollection,
   If(Column1 = "No" Or Column2 = "No" Or Column3 = "No",
      DoSomething
   )
)