I was wondering if you could help me. I am really hoping you can give me some insight. I am working on a canvas App. I work for Walmart Warehouse in Olive Branch, MS. I am trying to create an app for the pickers that allows multiple users to grab a cart, go to the mobile station that everyone will be using off of the same 365 account, Click Start Pick, and when they return, click End Pick, while the time spent with the cart is automatically calculated back to the SharePoint List. I got stuck somewhere and now I am lost. I wanted to use the Associate number as the unique identifier, but that didn't work. and I was originally using the patch tool to have both buttons working, but the problem I encountered is that multiple users will be using the app back to back, and it was all going under the same record. The upper management is starting to lose faith in me lol.. but I really want to solve this problem for myself. My question is how do i go back and update the records that are still active and match with the Associate number of the person who is at the mobile station?
My start button: Set(varNewItem, Patch(PickListTracker, Defaults(PickListTracker),{ Title: User().Email, CartSize:DataCardValue4.Selected, Units: Value(DataCardValue2.Text), CartNumber: Text (DataCardValue3.Text), Associate: Text(DataCardValue1.Text), StartTime: Now(), ActiveSession: true}))
My End Button: Set(varNewItem, Patch(PickListTracker, LookUp(PickListTracker, varNewItem.ID = ID), {EndTime: Now(), TimeSpent: DateDiff(varNewItem.StartTime, Now(), TimeUnit.Minutes), ActiveSession:false}))
