How to check if table is empty for each record and records inside an collection?

[Anonymous]

Hello,

We want to check all INCOTERMS column for each record in the collection but INCOTERM is in the subet collection of same record.

Example:

ShipTo is First Collection and ShippingInfo is subset of first Collection. (INCOTERMS IS IN THE ShippingInfo Collection)

Each record has shippingInfo collection as you see above. In ShippingInfo collection, 5 columns exist. See above. First Columns is INCOTERMS.

How to perform an mass check to see if each record in the shipTo collection to see - is INCOTERMS blank or not? Like to perform check on all records at once.

Some Formulas that we are playing with:

If(IsEmpty(LookUp(ShipTo,First(ShippingInfo).INCOTERMS1 = "")),"No Error","Error")

Thanks

[v-monli-msft]

Hi @Anonymous ,

What result do you want to have after the checking? Did you mean that you want to return an error if any one of these records has an empty value for INCOTERMS column?

Regards,

Mona

[Anonymous]

@v-monli-msft Yes that is correct

[Anonymous · Accepted solution]

@v-monli-msft  got a figure it out.  Have to use the ForAll function.

Example:

If(LookUp(ForAll(ShipTo, First(ShippingInfo).INCOTERMS1 = ""),value = true).Value = true, Set(Var, "Error"), Set(Var,"No Error"))