Power Platform Community Forum Thread Details

Real-Time Stock Synchronization Issue in Multi-User Order Application

Hi guys, I am working on order application, stock values are not updating correctly across sessions when multiple users place orders for the same item simultaneously. We need a solution to synchronize stock updates in real-time, ensuring accurate availability and preventing overselling.Can you guys please help me with this problem.

And here is my code:

ClearCollect(myapplica,
ForAll(
    Gallery2.AllItems,
    LookUp(Products,ID=ThisRecord.ID
));



Set(myorder,orderid.Run().orderid);
Patch(
    Orders,LookUp(Orders,Title=myorder),
    {
        'Item Count': Value(Label21.Text),
        'Total Amount': Value(Label9.Text)
    }
);
ForAll(
    Gallery2.AllItems,
    Patch(
        'product Items',
        Defaults('product Items'),
        {
            Title: ThisRecord.Label5.Text,
            Quantity: ThisRecord.Label6.Text,
            Amount: ThisRecord.Label7.Text,
            'Order ID':{Value:"",Id:LookUp(Orders,Title=myorder,ID)}
        }
    )
);
ForAll(
    Gallery2.AllItems,
    Patch(
        Products,LookUp(Products,Title=Label5.Text),{Stock:Value(ThisRecord.Label6_1.Text)})
);
Refresh(Products);
UpdateContext({varplace:true});

Categories:

Power Apps component framework

Power Platform Build Tools

Refresh(Products); ClearCollect(myapplica, ForAll( Gallery2.AllItems, LookUp(Products,ID=ThisRecord.ID )); Set(myorder,orderid.Run().orderid); Patch( Orders,LookUp(Orders,Title=myorder), { 'Item Count': Value(Label21.Text), 'Total Amount': Value(Label9.Text) } ); ForAll( Gallery2.AllItems, Patch( 'product Items', Defaults('product Items'), { Title: ThisRecord.Label5.Text, Quantity: ThisRecord.Label6.Text, Amount: ThisRecord.Label7.Text, 'Order ID':{Value:"",Id:LookUp(Orders,Title=myorder,ID)} } ) ); ForAll( Gallery2.AllItems, Patch( Products,LookUp(Products,Title=Label5.Text),{Stock:Value(ThisRecord.Label6_1.Text)}) ); Refresh(Products); UpdateContext({varplace:true});

Quick Links