web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Lookup 2 values in for...

Power Apps

Answered

Lookup 2 values in formula

(0) Share

Report

Report

Posted on by Atran7785

55

Hi Everyone, not sure if this make sense but. Is it possible to lookup using 2 criterias? Right now this is the formula:

LookUp('[dbo].[SecondaryInvestor_Types]',gen_id=BrowseGallery1.Selected.gen_id)

But i need to look up both Gen_ID+Program in order to pinpoint the exact row of info from Sql.

Right now in the browsing screen when I select a different program, it will always show info from the 1st program on that list.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Atran7785 ,

Have you tried nesting a "And()" function inside your "Lookup()" condition?

LookUp('[dbo].[SecondaryInvestor_Types]',And(gen_id=BrowseGallery1.Selected.gen_id;Program=something))

Was this reply helpful? Yes No
Atran7785 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Wizey,

Appreciate your help. Unfortunately that didn't work(Maybe i did something wrong)

LookUp('[dbo].[SecondaryInvestor_Types]',And(gen_id=BrowseGallery1.Selected.gen_id; Program=BrowseGallery1.Selected.Program))

Error messages:

Incompatible types for comparison.
Delegation Warning

Was this reply helpful? Yes No
Verified answer

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Sorry, I used a semi-colon instead of a comma.

Try again with this code please:

LookUp('[dbo].[SecondaryInvestor_Types]', And(gen_id=BrowseGallery1.Selected.gen_id, Program=BrowseGallery1.Selected.Program))

Was this reply helpful? Yes No
Atran7785 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much! It worked!

Was this reply helpful? Yes No

Join the conversation