Default value if lookup doesn't find any record

[aarnav]

Hi all,

I am trying to store value of  Level1 column of data source CustGrp  to a collection varGroup where customerNo equals 1234. 

I need to pass another field (say Level2) if below lookup fails to match any record in CustGrp data source.

Collect(varGroup,LookUp(CustGrp,CustomerNo = '1234',Level1));

is this possible?

Thanks,

[PVosEska · Accepted solution]

Hi @aarnav , how is this?

With the With() Function, you can create a temporary variable just during the execution of the formula. If you put the LookUp() in this with, you can check the result afterwards and handle it.

Example:

With(
    {
        tempvar: LookUp(
                    CustGrp, 
                    customerNo = 1234,
                    Level1
                 )
     },
     If(
         !IsBlank(tempvar),
         <Collect here>,
          IsBlank(tempvar),
         <other collect here>
     )
)

Good luck!

[zmorek · Accepted solution]

With(LookUp(CustGrp,CustomerNo=1234), Collect(varGroup,Coalesce(Level1, Level2)))