web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Lookup With Two Condit...

Power Apps

Unanswered

Lookup With Two Conditions

(0) Share

Report

Report

Posted on by RJF61

1,265

I have the following as the Default property of a field in a Power App.

If(!IsBlank(DataCardValue102.Selected),LookUp(ShopRateInfo,CraftSR = DataCardValue102.Selected.CraftSR).CraftRate)

The format works properly until I add the portion underlined below.

If(!IsBlank(DataCardValue102.Selected),LookUp(ShopRateInfo,CraftSR = DataCardValue102.Selected.CraftSR && FiscalYear = Text(DataCardValue2)).CraftRate)

Essentially I want to lookup up a value in SP List "ShopRateInfo" when there is a match as follows...

Any suggestions how to address?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Hassan_SZ_365 542 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RJF61 ,

Use this formula:

If( !IsBlank(DataCardValue102.Selected), LookUp( ShopRateInfo, CraftSR = DataCardValue102.Selected.CraftSR && FiscalYear = Text(DataCardValue2.Text) ).CraftRate )

Key Points:
Make sure CraftSR and FiscalYear are the correct internal names of the fields in the "ShopRateInfo" SharePoint list.
DataCardValue102.Selected.CraftSR should correctly refer to the selected item's CraftSR property from DataCardValue102.
Text(DataCardValue2.Text) should be changed to match the exact property of DataCardValue2 that holds the Fiscal Year. If DataCardValue2 is a Text Input control, DataCardValue2.Text is correct. If it's a different type of control (like a DatePicker), you'll need to adjust the formula to reference the correct property for the Fiscal Year.
This formula will perform a lookup in the "ShopRateInfo" list where both the CraftSR and FiscalYear conditions are met and return the CraftRate for the matched item.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Hassan_SZ_365 So that did work; however, I have one more field column that did function properly. In this case CraftSR in ShopRateInfo is "SUPV". I want to pull the value where CraftSR = "SUPV" and FiscalYear = 2023.

LookUp(ShopRateInfo,CraftSR = "SUPV" && FiscalYear = Text(DataCardValue2.Text)).CraftRate

I am receiving...

Was this reply helpful? Yes No

Join the conversation