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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,117)