web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Lookup on multiple col...

Power Apps

Answered

Lookup on multiple columns

(0) Share

Report

Report

Posted on by sheladia Microsoft Employee

Hi,

I want to do lookup on two fields - like below
AddColumns(
tmpcoll,
"isAvail",
If(
!IsBlank(
LookUp(
tmptbl,
'emp Id' = Result,
deptId = tmpDeptId,
'emp Id'
)
),
true,
false
)

);

Is there any alternative ways to achieve this? I want to add multiple columns based on some condition.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@sheladia
Here's the solution 🙂

AddColumns( tmpcoll, "isAvail", !IsBlank( LookUp( tmptbl, 'emp Id' = Result AND deptId = tmpDeptId, 'emp Id' ) ) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
sheladia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@mdevaney, You are simply Awesome 🙂
It works.
Thank You!

Was this reply helpful? Yes No

Join the conversation