Perform two lookups for same patch

(0) Share

Report

Posted on by likhith117

Need help in updating master list

I performed a patch to update Issue qty in master list with this code.

Patch(
Consumable_Master,
LookUp(
Consumable_Master,
Value(Dropdown1.Selected.'Item Code') = Value('Item Code')
),
{'Issue Qty': Value(DataCardValue6.Text) + Value(Dropdown1.Selected.'Issue Qty')}
);

problem is

Now I need to update on two criteria.one is lookup performed in the formula.

and another is Type (choice data type) =Issue.

If Type = Purchase it should update PURCHASE qty in master list.

please help in devolping the formula.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @likhith117 ,

Could you please share more details about your scenario? Would you like to update different column's value base on the Type column which is a Choice column?

If so, please try below formula:

Switch( Type.Value, "Purchase", Patch( Consumable_Master, LookUp( Consumable_Master, Value(Dropdown1.Selected.'Item Code') = Value('Item Code') ), { 'Purchase Qty': ...) } ), "Issue", Patch( Consumable_Master, LookUp( Consumable_Master, Value(Dropdown1.Selected.'Item Code') = Value('Item Code') ), { 'Issue Qty': Value(DataCardValue6.Text) + Value(Dropdown1.Selected.'Issue Qty') } ) );

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
likhith117 68 on at

Like (0)

Report
Copy link

Link copied!

Hey @v-jefferni Thanks for the help its working.

One problem is The submit button contains two functions Patch and submit form.
If for example Someone didn't give any thing in required fields and click submit.The patch function updating the list but form not submitting.It becomes a problem in this case. please figure out a formula for this (Iferror kind of ones I expect)

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @likhith117 ,

Type selecting is a Combo box? If so, you will need:

TypeCombobox.Selected.Value

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No