web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Default value if looku...

Power Apps

Answered

Default value if lookup doesn't find any record

(0) Share

Report

Report

Posted on by Aarnav

59

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,

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

PVosEska 329 on at

Like
a
(1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
Verified answer

zmorek 3,272 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation