Answered

I need Help with the LookUp Function

(0) Share

Report

Posted on by Yakkek

I have an inventory system.
The square in YELLOW is where my problem is.
What's marked in GREEN are from the same database.
The variable "qtde" represents the quantity column of the database.

The variable "Arrqtde" represents the quantity that will be deducted from the stock.

My problem is here on the second qtde: qtde: qtde - Value(Arrqtde)
The second qtde is supposed to be the live amount of items in the stock of that specific LookUp record (because is in a collect), but I don't know what I'm missing here.

I need that the second qtde to represent the live amount of items in the stock of that LookUp Record.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Yakkek Do you mind posting the formula in the chat.
Verified answer

Scott_Parker 1,090 on at

Like
a
(1)

Report
Copy link

Link copied!
Note that I wrote this using the semicolon syntax based on your region, but I might have made mistakes since I normally use commas between function arguments.

The second qtde is coming from arrPedido. That is because you are inside the scope of the ForAll function at that point, not the LookUp function. Lookup has already run and returned a record. If you wanted to use that record in multiple places, you could use a With() that sets the lookup to a locally scoped variable, e.g.:

ForAll( arrPedido; With({xRecord: LookUp('public.bra_pa_cadastro_producto'; produto_referencia = Arreproducto_referencia)}; Patch('public.bra_pa_cadastro_producto'; xRecord; {qtde: xRecord.qtde - Value(Arrqtde)}); ) ) );;

All that said, you can use an UpdateIf instead:

UpdateIf( 'public.bra_pa_cadastro_producto'; produto_referencia = Arreproducto_referencia; {qtde: qtde - Value(Arrqtde)} );;
Yakkek 5 on at

Like
a
(0)

Report
Copy link

Link copied!

ForAll(
arrPedido;
Patch(
'public.bra_pa_cadastro_produto';
LookUp('public.bra_pa_cadastro_produto';
produto_referencia = Arrproduto_referencia);
{
qtde: qtde - Value(Arrqtde)
}
)
);;