ID for a Batch (like shopping cart)

(0) Share

Report

Posted on by pwagma

Hello

Im working on an app to create new selling orders. It works as a shopping cart.

The thing is that I am saving the information on Sharepoint List, every item is a new line on the List.

But 1 order may have 5 items inside, so on the list I will have 5 lines, and I want all of them to have the same order number.

Finally, I need to execute this action at the end of the process, since different users will use the app at the same time, I cannot create the ID when I create the item, I need to do it when I send the order confirmation.

The Items added to the order are managed inside a collection.

Basically I need to: check the last order number (I do it with first-->sort.descending), and then with a for all (or something like that), add that number to all the collection (must always be the same number) and add the collection to the list.

Example picture, the "number order" it is under the tag "Numero de Pedido".

Thanks,

Pablo

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

All you need to do is Submit the "order" form first, then you can set a variable to the LastSubmit of that form. Us that ID number to populate the list of "items" in the order. Check out this series of videos:
https://www.youtube.com/watch?v=xgznk4XlPCo

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi@pwagma,
Based on the issue that you mentioned, do you want to save the order number to the SP list?
Could you please share a bit more about your app configuration, how you design your app?
Actually, I could not get your SP list data set, this 'Cliente' represents the customer? If so, why don't you add a column to store the order amount which avoids the repeated clients and get you a unique order number?
I have made a test on my side, please take a try as below.
Set the Default property of the TextInput control belongs to the OrderNumber DataCard as below:

If( CountRows( Filter( Pedidos, Cliente.Value = DataCardValue5.Selected.Value ) ) >0, Value( LookUp( Pedidos, Cliente.Value = DataCardValue5.Selected.Value, 'OrderNumber (Client)' ) ), Value(Last(Pedidos.'OrderNumber (Client)').'OrderNumber (Client)') + Value(1) )

Note: In my SP list, the 'Client' is a Choice column.
Best Regards,
Qi

Was this reply helpful? Yes No