cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
forbudt4u
Helper III
Helper III

Patch, Flow or Both - Bulk Qty Assets

Hello... I am getting real close to finishing up an app we've been working on for a year.  But, there has been one component of this added to the mix that wasn't originally part of our plans.  In short, we have an Asset Management/Tracker that was intended to manage single record/assets with unique QR Codes for each individual asset.  We are wanting to expand our tracking for assets that we consider Bulk Qty Assets... kind of like the grocery store where we'll have the same ScanTag# (which is the QR Code) but multiples of them held by multiple people.  Our current app patching works well for our current environment, but we know we'll have to change things a bit due to this newest feature we are wanting. 

 

I have provided below a chart that shows the 4 scenarios we will run into when it comes to updating records in the SharePoint list when a Transfer Button is pressed in the app.  We basically have 3 components to this... The Person (Transferrer or Transferee), The Record (whether the Transferrer or Transferee has the current ScanTag# in their List), and the Quantity (the current or desired Qty).  The last piece of the puzzle is the reason for my post... what happens when each of the 4 scenario's are true?  My question is what would be the best route to take in patching the records in SharePoint based on what I have provided... Patching, a Flow or a combination of both... and what are the reasons behind and recommendations for carrying it out?  

 

Bulk Qty Options.PNG

This is our current patch that updates records in the SharePoint List based on our current single record environment... thought it would help shed light on the list and column names.  

 

Patch(
        'All Asset List',
        ThisRecord,
        {
            Holder: TransferToSelect_2.Selected.Title,
            Status: {
                ID: 1,
                Value: HardTransferStatusDrpDwn_1.Selected.Value
            },
            LocationBK: TransferToSelect_2.Selected.Location.Value,
            'Asset Site': TransferToSelect_2.Selected.'Asset Site'.Value,
            'Transfer Status': "",
            'Audit Status': "Pending",
            'Retired Date': If(HardTransferStatusDrpDwn_1.Selected.Value="Retired",DatePicker2_2.SelectedDate,
            Blank())
        }
    );

 

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,882)