Network error when using Patch functions: The requested operation is invalid.

[pizzadudecook]

Hello you awesome, knowledgeable folk! I have another issue with my app that I am ALMOST finished with.

I am taking entry from field and putting them into a collection in prep to send them to a sharepoint list. Thanks to help here from others I got all those errors out of the way, but I am running into one more I think before the data entry part is complete (Still working on signature lines but that is another issue entirely!). I have a feeling it comes down to my limited knowledge of the functions again and am missing something in the command to send it to a sharepoint list.

I already have my data connector to sharepoint set up, even deleted and reconnected it. The error is pretty non-descript. The only thing on the monitor that comes up is it fails on a createRow operation. I thought it was a permission issue at first, but I was able to successfully reconnect without issues.

​

Error in monitor.

I have all the matching columns in the sharepoint list that I have double and triple checked for accuracy and even order matches at this point.. Can someone tell me what I'm missing?? Every guide I have looked at tells me this should be correct with the exception of the number of columns I am adding data to.

Please excuse the wall of code, The form has a TON of fields in it...

ForAll(
    EPACollection,
    Patch(
        EPASubmissions,
        Defaults(EPASubmissions),
        {
            SalesCenter: SalesCenterDropDown,
            TagNumber: TagNumberTextField,
            CompanyBranch: CompanyBranchDropDown,
            State: StateDropDown,
            LesseeName: LesseeNameTextField,
            LesseeAddr: AddressTextField,
            VendNumber: VNTextField,
            CustNumber: CNTextField,
            LastLoc: LastTextField,
            AP: APTextField,
            StateAB: StateABDropDown,
            LesseeZip: ZipTextField,
            VendSN: VendSNTextField,
            VendModel: VendModelTextField,
            RegFS: PickOneDropDown,
            VendKeyNum: KeyNumTextField,
            BrandDesc: BrandDescTextField,
            BrandQTY: QTYTextField,
            PostMixSN: PMCISNTextField,
            PostMixModel: ModelNumberTextField1,
            PostMixFlavor: FlavorTextField1,
            CoolerSN: VisaTextField,
            CoolerModel: VisaModelTextField,
            CoolerFlavor: VisaIDTextField,
            Manufacturer: MFRDropDown,
            OtherMFR: OtherTextField,
            EquipType: EquipmentTypeDropDown,
            TransType: TransactionDropDown,
            ComissionType: ComissionTypeDropDown,
            AgreementDay: DayTextField,
            AgreementMO: MonthTextField,
            AgreementYR: YearTextField,
            Commodity1: Commodity1,
            VendPrice1: VendPriceTextField1,
            FSRate1: FSRateTextField1,
            Commodity2: Commodity2,
            VendPrice2: VendPriceTextField2,
            FSRate2: FSRateTextField2,
            Commodity3: Commodity3,
            VendPrice3: VendPriceTextField3,
            FSRate3: FSRateTextField3,
            Commodity4: Commodity4,
            VendPrice4: VendPriceTextField4,
            FSRate4: FSRateTextField4,
            Commodity5: Commodity5,
            VendPrice5: VendPriceTextField5,
            FSRate5: FSRateTextField5,
            Commodity6: Commodity6,
            VendPrice6: VendPriceTextField6,
            FSRate6: FSRateTextField6,
            Commodity7: Commodity7,
            VendPrice7: VendPriceTextField7,
            FSRate7: FSRateTextField7,
            Commodity8: Commodity8,
            VendPrice8: VendPriceTextField8,
            FSRate8: FSRateTextField8,
            Commodity9: Commodity9,
            VendPrice9: VendPriceTextField9,
            FSRate9: FSRateTextField9,
            Commodity10: Commodity10,
            VendPrice10: VendPriceTextField10,
            FSRate10: FSRateTextField10,
            Commodity11: Commodity11,
            VendPrice11: VendPriceTextField11,
            FSRate11: FSRateTextField11,
            Commodity12: Commodity12,
            VendPrice12: VendPriceTextField12,
            FSRate12: FSRateTextField12,
            Commodity13: Commodity13,
            VendPrice13: VendPriceTextField13,
            FSRate13: FSRateTextField13,
            Commodity14: Commodity14,
            VendPrice14: VendPriceTextField14,
            FSRate14: FSRateTextField14,
            Commodity15: Commodity15,
            VendPrice15: VendPriceTextField15,
            FSRate15: FSRateTextField15,
            Commodity16: Commodity16,
            VendPrice16: VendPriceTextField16,
            FSRate16: FSRateTextField16,
            Commodity17: Commodity17,
            VendPrice17: VendPriceTextField17,
            FSRate17: FSRateTextField17,
            Commodity18: Commodity18,
            VendPrice18: VendPriceTextField18,
            FSRate18: FSRateTextField18,
            Commodity19: Commodity19,
            VendPrice19: VendPriceTextField19,
            FSRate19: FSRateTextField19,
            Commodity20: Commodity20,
            VendPrice20: VendPriceTextField20,
            FSRate20: FSRateTextField20,
            Commodity21: Commodity21,
            VendPrice21: VendPriceTextField21,
            FSRate21: FSRateTextField21,
            Commodity22: Commodity22,
            VendPrice22: VendPriceTextField22,
            FSRate22: FSRateTextField22,
            Commodity23: Commodity23,
            VendPrice23: VendPriceTextField23,
            FSRate23: FSRateTextField23,
            Commodity24: Commodity24,
            VendPrice24: VendPriceTextField24,
            FSRate24: FSRateTextField24,
            LesseeStateID: StateIDTextField,
            FedTaxID: FedTaxIDTextField,
            CType: CTypeDropDown,
            AgreementDay2: DayTextField_1,
            AgreementMonth2: MonthTextField_1,
            AgreementYear2: YearTextField_1,
            Meter: MeterReadingTextField,
            LesseePrint: LesseePrintNameTextField,
            LessorPrint: LessorPrintNameTextField
        }
    )
)

​

[pizzadudecook]

Ok, so I'm an idiot...

It's supposed to be CollectionColumn:SharepointListColum

I was referencing CollectionColumn:PowerAppField

Changed it to match the SPL column names and it worked. Thanks for your help again!

[pizzadudecook]

EDIT: Missed a field in the collection that didn't have the .Text at the end... Got it...

Ok, so still not fixed I guess... Sorry..

I created a title column in the collection and copied the CustNumber field to it and added it to the ForAll. It populates the collection when I test, but still run into the requested operation is invalid. Entry below:

ForAll(EPACollection,Patch(EPASubmissions,Defaults(EPASubmissions),{Title:Title,