Power Platform Community Forum Thread Details

Hello,

I am using the below patch statement for patching various fields in an app to a SharePoint list.

If I select all the fields in the app and use the Submit button, then all selected data is created in a new list item, however if I only select 1 item (e.g. FemaleShortSleeveWhiteShirtSize, FemaleShortSleeveWhiteShirtBust and

FemaleShortSleeveWhiteShirtQty) then this is not saved to SharePoint - the item is still created but the selected sizes are not published to the list - although these do show when they are added with other items.
 
If you need any other info about the app, please let me know.

/* THIS IS THE START OF THE PATCH FUNCTION THAT WILL PATCH DATA TO ASSOCIATED SHAREPOINT LIST COLUMNS */
Set(
varCurrentRecord,
Patch(
'Uniform order form',
varCurrentRecord,
{
    Title: Name.Text,
    Manager: Manager.Text,

// THIS WILL PATCH BASIC TEXT DATA TO SHAREPOINT LIST
    AddressLine1: AddressLine1.Text,
    AddressLine2: AddressLine2.Text,
    BeanieQty: If( BeanieQty.Text = "0", Blank(), BeanieQty.Text),
    BumpHatQty: If( BumpHatQty.Text = "0", Blank(), BumpHatQty.Text),
    BeechfieldCargoBucketHatQty: If( BucketHatQty.Text = "0", Blank(), BucketHatQty.Text),
    City: CityTown.Text,
    FemaleCleanJanQty: If( FemaleCleanJanQty.Text = "0", Blank(), FemaleCleanJanQty.Text),
    FemaleMascotShortsQty: If( FemaleMascotShortsQty.Text = "0", Blank(), FemaleMascotShortsQty.Text),
    FemaleOxfordWhiteShirtQty: If( FemaleOxfordWhiteShirt_Qty.Text = "0", Blank(), FemaleOxfordWhiteShirt_Qty.Text),
    FemaleShortSleeveWhiteShirtQty: If( FemaleShortSleeveWhiteShirt_Qty.Text = "0", Blank(), FemaleShortSleeveWhiteShirt_Qty.Text),
    GloveSize: GloveSize.Text,
    GlovesQty: If( GlovesQty.Text = "0", Blank(), GlovesQty.Text),
    HiVisJacketQty: If( HiVisJacketQty.Text = "0", Blank(), HiVisJacketQty.Text),
    HiVisWaistcoatQty: If( HiVisWaistcoatQty.Text = "0", Blank(), HiVisWaistcoatQty.Text),
    LadiesFleeceQty: If( FemaleFleeceQty.Text = "0", Blank(), FemaleFleeceQty.Text),
    LadiesHolsterPocketTrousersQty: If( LadiesHolsterTrousersQty.Text = "0", Blank(), LadiesHolsterTrousersQty.Text),
    LadiesOfficeTrousersQty: If( LadiesOfficeTrousersQty.Text = "0", Blank(), LadiesOfficeTrousersQty.Text),
    MaleBerteeShortsQty: If( MaleBerteeShortsQty.Text = "0", Blank(), MaleBerteeShortsQty.Text),
    MaleBlackOfficeTrousersQty: If( MaleBlackOfficeTrousersQty.Text = "0", Blank(), MaleBlackOfficeTrousersQty.Text),
    MaleCleanJanQty: If( MaleCleanJanQty.Text = "0", Blank(), MaleCleanJanQty.Text),
    MaleOxfordWhiteShirtQty: If( MaleOxfordWhiteShirt_Qty.Text = "0", Blank(), MaleOxfordWhiteShirt_Qty.Text),
    MaleShortSleeveWhiteShirtQty: If( MaleShortSleeveWhiteShirt_Qty.Text = "0", Blank(), MaleShortSleeveWhiteShirt_Qty.Text),
    MensFleeceQty: If( MensFleeceQty.Text = "0", Blank(), MensFleeceQty.Text),
    MensHolsterPocketTrousersQty: If( MensHolsterTrousersQty.Text = "0", Blank(), MensHolsterTrousersQty.Text),
    UnisexPoloShirtQty: If( UniSexPoloShirtQty.Text = "0", Blank(), UniSexPoloShirtQty.Text),
    PPEPackQty: If( PPEPackQty.Text = "0", Blank(), PPEPackQty.Text),
    Postcode: Postcode.Text,
    ReplacementLaces90cmQty: If( LacesQty.Text = "0", Blank(), LacesQty.Text),
    SoftshellUnisexQty: If( SoftShellUnisexQty.Text = "0", Blank(), SoftShellUnisexQty.Text),
    UnisexShortsBlackQty: If( UnisexShortsBlackQty.Text = "0", Blank(), UnisexShortsBlackQty.Text),
    UnisexSweatshirtQty: If( UnisexSweatshirtQty.Text = "0", Blank(), UnisexSweatshirtQty.Text),
    UnisexTradesHolsterQty: If( UnisexTradesHolsterQty.Text = "0", Blank(), UnisexTradesHolsterQty.Text),
    UnisexWaterJackQty: If( UnisexWaterproofQty.Text = "0", Blank(), UnisexWaterproofQty.Text),
    WhiteHardHatQty: If( HardHatQty.Text = "0", Blank(), HardHatQty.Text),
    OtherColleagueName: OtherColleagueName.Text,

// THIS WILL PATCH YES/NO COLUMNS TO SHAREPOINT LIST
    PPEPack: PPEPack_tgl.Value,
    ReplacementLaces90cm: Laces_tgl.Value,
    HasColleagueStartedYet: HasColleagueStartedYet_tgl.Value,

// THIS WILL PATCH COMPLEX CHOICE DATA TO SHAREPOINT CHOICE COLUMNS
    Beanie: {Value: Beanie_dd.Selected.Value},
    BumpHat: {Value: BumpHat_dd.Selected.Value},
    BeechfieldCargoBucketHat: {Value: BucketHat_dd.Selected.Value},
    HiVisJacket: {Value: HiVisJacket_dd.Selected.Value},
    HiVisWaistcoat: {Value: HiVisWaistcoat_dd.Selected.Value},
    LadiesFleece: {Value: LadiesFleece_dd.Selected.Value},
    MensFleece: {Value: MensFleece_dd.Selected.Value},
    UnisexPoloShirt: {Value: UnisexPoloShirt_dd.Selected.Value},
    WhiteHardHat: {Value: WhiteHardHat_dd.Selected.Value},
    UnisexWaterproofJacket: {Value: UnisexWaterproofJacket_dd.Selected.Value},
    SoftshellUnisex: {Value: SoftShellUnisex_dd.Selected.Value},
    UnisexSweatshirt: {Value: UnisexSweatshirt_dd.Selected.Value},
    LadiesOfficeTrousersLegLength: {Value: LadiesOfficeTrousersLL_dd.Selected.Value},
    LadiesHolsterPocketTrousersLL: {Value: LadiesHolsterTrousersLL_dd.Selected.Value},
    FemaleCleanJanLL: {Value: FemaleCleanJanLL_dd.Selected.Value},
    UnisexTradesHolsterLL: {Value: UnisexTradesHolsterLL_dd.Selected.Value},
    MaleCleanJanLL: {Value: MaleCleanJanLL_dd.Selected.Value},
    MaleBlackOfficeTrousersLL: {Value: MaleBlackOfficeTrousersLL_dd.Selected.Value},

// THIS WILL PATCH CHOICE DATA TO SHAREPOINT TEXT COLUMNS

    FemaleCleanJanWaist: FemaleCleanJanWaist_dd.Selected.Result,
    FemaleCleanJanSize: FemaleCleanJanSize_dd.Selected.Result,
    FemaleMascotShortsSize: FemaleMascotShortsSize_dd.Selected.Result,
    FemaleOxfordWhiteShirtBust: FemaleOxfordWhiteShirtBust_dd.Selected.Result,
    FemaleOxfordWhiteShirtSize: FemaleOxfordWhiteShirtSize_dd.Selected.Result,
    FemaleShortSleeveWhiteShirtSize: FemaleShortSleeveWhiteShirtSize_dd.Selected.Result,
    FemaleShortSleeveWhiteShirtBust: FemaleShortSleeveWhiteShirtBust_dd.Selected.Result,
    LadiesHolsterPocketTrousersSize: LadiesHolsterTrousersSize_dd.Selected.Result,
    LadiesHolsterPocketTrousersWaist: LadiesHolsterTrousersWaist_dd.Selected.Result,
    LadiesOfficeTrousersSize: LadiesOfficeTrousersSize_dd.Selected.Result,
    LadiesOfficeTrousersWaist: LadiesOfficeTrousersWaist_dd.Selected.Result,
    MaleBerteeShortsWaist: MaleBerteeShortsWaist_dd.Selected.Result,
    MaleBlackOfficeTrousers: MaleBlackOfficeTrousersWaist_dd.Selected.Result,
    MaleCleanJan: MaleCleanJanWaist_dd.Selected.Result,
    MaleOxfordWhiteShirtChest: MaleOxfordWhiteShirtChest_dd.Selected.Result,
    MaleOxfordWhiteShirtNeck: MaleOxfordWhiteShirtNeck_dd.Selected.Result,
    MaleShortSleeveWhiteShirtNeck: MaleShortSleeveWhiteShirtNeck_dd.Selected.Result,
    MaleShortSleeveWhiteShirtChest: MaleShortSleeveWhiteShirtChest_dd.Selected.Result,
    MensHolsterPocketTrousersLL: MensHolsterTrousersLL_dd.Selected.Result,
    MensHolsterPocketTrousersWaist: MensHolsterTrousersWaist_dd.Selected.Result,
    ShoeBootName: ShoeBootName_dd.Selected.Result,
    ShoeBootSize: ShoeBootSize_dd.Selected.Result,
    UnisexShortsBlack: UnisexShortsBlackWaist_dd.Selected.Result,
    UnisexTradesHolsterWaist: UnisexTradesHolsterWaist_dd.Selected.Result

    }
)
);

// THIS WILL CHECK FOR ERRORS
If(
    IsEmpty(Errors('Uniform order form')),
    // ON SUCCESS
    UpdateContext({locFormDisplayMode: "View"}); //
    Notify(
        "Success: Uniform Order Form Submitted",
        NotificationType.Success
    ),
    // ON FAILURE
    Notify(
        "Errors: Unable to Submit Uniform Order Form",
        NotificationType.Error
    )
);

// THIS WILL RESET ALL FIELDS WHEN THE FORM HAS BEEN SUBMITTED */

// CLEAR VARIABLES
Set(varCurrentRecord, Blank());
UpdateContext({locFormDisplayMode: Blank()});

// RESET CONTROLS
Set(varResetthemAll, true);
Set(varResetthemAll, false);

/* THIS WILL NAVIGATE THE USER TO THE SUCCESS SCREEN */
Navigate(Success_Scrn,ScreenTransition.Fade)

Categories:

Design & build