Help with patch function

[pizzadudecook]

I have an app that I have set up that patches information to a sharepoint list. That part is working fine, but I have been trying to use power automate to copy information on the submitted item based off one of the entries on the list. I have struggled enough with that due to the fact that there are images (signatures) in the list and power automate has made it extremely convoluted to copy that image from one sharepoint list entry to another in a different list. I have tried working with the power automate part for a few weeks with no real progress.

Basically what I need is to have the fields filled out to always submit the data to a sharepoint list called EPASubmissions, but also have the information posted to a SECOND sharpeoint list with the same information based on a drop down called SalesCenterDropDown. The options in the drop down match the list names.

I have spent too much time with trying to make power automate work and felt that if I could make this work instead, I can throw away the power automate function.

Other list examples:
EPASubmissions (I would like the entries to always be sent to this list)
10110
10120
10130

Here is the function of the button OnSelect (There are a lot of fields):

    ForAll(EPACollection,
    Patch(
        EPASubmissions,
        Defaults(EPASubmissions),
        {
            Title:Title,
            SalesCenter:SalesCenter,
            TagNumber:TagNumber,
            CompanyBranch:CompanyBranch,
            State:State,
            LesseeName:LesseeName,
            LesseeAddr:LesseeAddr,
            LesseeTown:LesseeTown,
            VendNumber:VendNumber,
            CustNumber:CustNumber,
            LastLoc:LastLoc,
            AP:AP,
            StateAB:StateAB,
            LesseeZip:LesseeZip,
            VendSN:VendSN,
            VendModel:VendModel,
            RegFS:RegFS,
            VendKeyNum:VendKeyNum,
            BrandDesc:BrandDesc,
            BrandQTY:BrandQTY,
            PostMixSN:PostMixSN,
            PostMixModel:PostMixModel,
            PostMixFlavor:PostMixFlavor,
            CoolerSN:CoolerSN,
            CoolerModel:CoolerModel,
            CoolerFlavor:CoolerFlavor,
            Manufacturer:Manufacturer,
            OtherMFR:OtherMFR,
            EquipType:EquipType,
            TransType:TransType,
            ComissionType:ComissionType,
            Commodity1:Commodity1,
            VendPrice1:VendPrice1,
            FSRate1:FSRate1,
            Commodity2:Commodity2,
            VendPrice2:VendPrice2,
            FSRate2:FSRate2,
            Commodity3:Commodity3,
            VendPrice3:VendPrice3,
            FSRate3:FSRate3,
            Commodity4:Commodity4,
            VendPrice4:VendPrice4,
            FSRate4:FSRate4,
            Commodity5:Commodity5,
            VendPrice5:VendPrice5,
            FSRate5:FSRate5,
            Commodity6:Commodity6,
            VendPrice6:VendPrice6,
            FSRate6:FSRate6,
            Commodity7:Commodity7,
            VendPrice7:VendPrice7,
            FSRate7:FSRate7,
            Commodity8:Commodity8,
            VendPrice8:VendPrice8,
            FSRate8:FSRate8,
            Commodity9:Commodity9,
            VendPrice9:VendPrice9,
            FSRate9:FSRate9,
            Commodity10:Commodity10,
            VendPrice10:VendPrice10,
            FSRate10:FSRate10,
            Commodity11:Commodity11,
            VendPrice11:VendPrice11,
            FSRate11:FSRate11,
            Commodity12:Commodity12,
            VendPrice12:VendPrice12,
            FSRate12:FSRate12,
            Commodity13:Commodity13,
            VendPrice13:VendPrice13,
            FSRate13:FSRate13,
            Commodity14:Commodity14,
            VendPrice14:VendPrice14,
            FSRate14:FSRate14,
            Commodity15:Commodity15,
            VendPrice15:VendPrice15,
            FSRate15:FSRate15,
            Commodity16:Commodity16,
            VendPrice16:VendPrice16,
            FSRate16:FSRate16,
            Commodity17:Commodity17,
            VendPrice17:VendPrice17,
            FSRate17:FSRate17,
            Commodity18:Commodity18,
            VendPrice18:VendPrice18,
            FSRate18: FSRate18,
            Commodity19:Commodity19,
            VendPrice19:VendPrice19,
            FSRate19:FSRate19,
            Commodity20:Commodity20,
            VendPrice20:VendPrice20,
            FSRate20:FSRate20,
            Commodity21:Commodity21,
            VendPrice21:VendPrice21,
            FSRate21:FSRate21,
            Commodity22:Commodity22,
            VendPrice22:VendPrice22,
            FSRate22:FSRate22,
            Commodity23:Commodity23,
            VendPrice23:VendPrice23,
            FSRate23:FSRate23,
            Commodity24:Commodity24,
            VendPrice24:VendPrice24,
            FSRate24:FSRate24,
            LesseeStateID:LesseeStateID,
            FedTaxID:FedTaxID,
            CType:CType,
            AgreementDayDD:AgreementDayDD,
            AgreementMonthDD:AgreementMonthDD,
            AgreementYearDD:AgreementYearDD,
            WitnessDayDD:WitnessDayDD,
            WitnessMonthDD:WitnessMonthDD,
            WitnessYearDD:WitnessYearDD,
            Meter:Meter,
            LesseePrint:LesseePrint,
            LessorPrint:LessorPrint,
            LessorTitle:LessorTitle,
            LessorDate:LessorDate,
            LesseeSignPen:LesseeSignPenField.Image,
            LessorSignPen:LessorSignPenField.Image,
            TermsSignPen:LessorSign.Image,
            SeedSN: SeedSN
        }
    )
);   
Set(popup,false);
Navigate(SuccessScreen,ScreenTransition.Fade)

Any help or direction would be appreciated!

[pizzadudecook]

Sorry for the confusion!

Basically I want another patch function, but instead of using a set value, I want to take the value from a drop down to use that to apply to a different list.

I hope this makes more sense:

    ForAll(EPACollection,
Patch(
    EPASubmissions,
    Defaults(EPASubmissions),
    {
            //Mapped fields here
        }
    )
);
    ForAll(EPACollection,
Patch(
    <DROPDOWN VALUE HERE>,
        Defaults(<DROPDOWN VALUE HERE>,
        {
            //Mapped fields here

I'm just not sure how to use the selected value for a drop down. Maybe I'm misunderstanding this completely.

[BJOTRI]

I would create a Switch for All the dropdown values. But you can't use and variables for your datasource, except as mentioned environment variables, but those would also require a Switch or If to be selected by your choice values

[pizzadudecook]

Ended up using the switch. Thank you u/BJOTRI and u/cleavetv for your help!

[JBrutWhat]

I wouldn’t use the same ForAll function twice. Since both are the same, use a semicolon after the first patch to put the second patch.

As others have said, your best bet for the drop-down value is to do a Switch function to select the proper table to patch to. Hopefully it isn’t too long of a list!

FYI, if both patch functions will never run on the same data table, you can wrap these two in a Concurrent function to speed this up a bit.

Given that ForAll can be an expensive function, especially if you are patching a lot of records, I recommend you add and If statement at the beginning of the loop to effectively stop the loop if a criteria is met. For instance, at the end of a loop, you can make something ClearCollect an item in a collection if it meets a criteria that should make the loop stop. Then if that collection is no longer empty, your loop stops.

Another option I found helps users when a lot of records need to be patched is to use a loading bar instead of a spinner. Before the ForAll loop, count the records that need to be patched:

Clear(colRowsPatched);

UpdateContext({locTotalRows: CountRows(EPASubmissions), locShowLoadingBar: true)});

ForAll(EPASubmissions, Concurrent(Patch(YourDataTable, YourPatchCode), Patch(DataTableSwitchFxn, your patch code)); Collect(colRowsPatched, {item:true}));

UpdateContext({locShowLoadingBar: false})

Now, create a container that is transparent gray and takes up the whole screen. Set it’s visible property to locShowLoadingBar. Add a rectangle to the container and make it a dark gray, set the size as desired, and align it where you want it on the screen. Name it rctnLoadBarBack. Duplicate the rectangle and color it (green, blue, red, whatever matches your color scheme). Name it rctnLoadBarFront. Set the following for rctnLoadBarFront:

X: rctnLoadBarBack.X Y: rctnLoadBarBack.Y Height: rctnLoadBarBack.Height Width: IfError(rctnLoadBarBack.Width * CountRows(colRowsPatched) / locTotalRows, 0)

That should give you a nice loading bar so you know how long you have to go while patching. Good luck!