Powerapps - Retake some order from an (SQL) table

(0) Share

Report

Posted on by loopingmurdock

250

Hey guys,

I have a problem, am trying to find a way how to reuse an order, i use a table to display the items and a form that display the select items where I can modify the QTYS of each items then a submit.

Once submitted by a SQL stored procedure all the QTYS and back to zero (table) and (database).

Am looking for a way to reuse the order and display to the table and database the some QTYs to the same items.

i Have tried :

UpdateIf(TableName, CollectionName)

Cant find the perfect conditions.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

You want to show your users the last order submitted, is that it?

Was this reply helpful? Yes No
loopingmurdock 250 on at

Like
a
(0)

Report
Copy link

Link copied!

I want the user to store the order for re-order, straight away

Was this reply helpful? Yes No
loopingmurdock 250 on at

Like
a
(0)

Report
Copy link

Link copied!
i tried this but is changes all the base
ForAll(TEST,UpdateIf([@Bills], Name = Etablishement, {Amount: QTY}))

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you have a Header, Detail struture in your orders?

Was this reply helpful? Yes No
loopingmurdock 250 on at

Like
a
(0)

Report
Copy link

Link copied!

no there an id order, the only thing i need to figure out is a way from a click of a button do the some order he/she previously did, after he/she submit it.

Was this reply helpful? Yes No
loopingmurdock 250 on at

Like
a
(0)

Report
Copy link

Link copied!
I store and submit the first order as such

Collect(TEST, {Name: DataCardValue1.Text, QTY: Value(DataCardValue3.Text) }); SubmitForm(Form1)

To re do the some order i do this but is changes everything, even items not order from zero to what ever he/she entered

ForAll( TEST, UpdateIf( [@Bills], Name = Etablishement, { Amount: QTY } ) )

UPDATE

i changed name to eta and it works
Can someone tell me way?

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @loopingmurdock ,

This can be caused by ambiguation. If the table 'TEST' and table 'Bills' have columns with the same name, an error may occur when nested calls.

You could also try this formula:

ForAll( TEST, UpdateIf( [@Bills] As TableA, TEST[@Name] = TableA[@Etablishement], { Amount: TEST[@QTY] } ) )

Best Regards,

Bof

Was this reply helpful? Yes No