Not supplied data source

(0) Share

Report

Posted on by LuFerri

Hey guys, I hope you all are having a great day.

I'm building an app with a SQL Server data conection, the basic app purpose is to get an item from the data base and them te user could patch the quantity of the items in stock.

But even though the formula seem ok I recive the runtime error bellow:

The code I'm using is bellow:

Set(QTT_A, LookUp(TABLE, COLUMN = Value(OP.Text)).QTT_DB_A);
Set(QTT_B, LookUp(TABLE, COLUMN = Value(OP.Text)).QTT_DB_B);

Patch(
 TABLE;
 Filter(TABLE, COLUMN = Value(OP.Text)),
 {
 QTT_DB_A: (QTT_A + Value(FIELD.Text)),
 QTT_DB_B: (QTT_B - Value(FIELD.Text))
 }
)

Thanks in advance and I hope you can help me.

Have a good day.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

timl 37,262 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@LuFerri

Assuming that you want to patch a single record, you should call the LookUp function to retrieve the target record, rather than Filter.

Also note that in your formula, the separator character after TABLE is a semi-colon. If you're using Power Apps in English, this should be a comma.

Patch( TABLE, LookUp(TABLE, COLUMN = Value(OP.Text)), { QTT_DB_A: (QTT_A + Value(FIELD.Text)), QTT_DB_B: (QTT_B - Value(FIELD.Text)) } )

Was this reply helpful? Yes No