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 (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 (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 (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 (0)

Report
Copy link

Link copied!

Thank you so much! It worked!

Was this reply helpful? Yes No

Join the conversation