Hello,
I'm having some issues with my OnSelect patch statement - this is patching data from PowerApps fields to a SharePoint list (not using the SharePoint edit/view form).
The problem seems to lie in the closing bracket and colon after the curly close bracket below - when I remove these, the only bit in Red is the opening Patch(
If anyone could help that would be awesome!!
Full patch statement below:
/* THIS IS THE START OF THE PATCH FUNCTION THAT WILL PATCH DATA TO ASSOCIATED SHAREPOINT LIST COLUMNS */
Patch(
'Uniform order form',
Defaults('Uniform order form'),
{
Title: User().FullName,
AddressLine1: AddressLine1.Text,
AddressLine2: AddressLine2.Text,
Beanie: Beanie_dd.Selected,
BeanieQty: BeanieQty.Text,
BumpHat: BumpHat_dd.Selected,
BumpHatQty: BumpHatQty.Text,
City: CityTown.Text,
FemaleClanJanSize: FemaleCleanJanSize_dd.Selected,
FemaleCleanJanLL: FemaleCleanJanLL_dd.Selected,
FemaleCleanJanQty: FemaleCleanJanQty.Text,
FemaleClanJanWaist: FemaleCleanJanWaist_dd.Selected,
FemaleMascotShortsSize: FemaleMascotShortsSize_dd.Selected,
FemaleMascotShortsQty: FemaleMascotShortsQty.Text,
FemaleOxfordWhiteShirtBust: FemaleOxfordWhiteShirtBust_dd.Selected,
FemaleOxfordWhiteShirtQty: FemaleOxfordWhiteShirt_Qty.Text,
FemaleOxfordWhiteShirtSize: FemaleOxfordWhiteShirtSize_dd.Selected,
GloveSize: GloveSize.Text,
GlovesQty: GlovesQty.Text,
HiVisJacket: HiVisJacket_dd.Selected,
HiVisJacketQty: HiVisJacketQty.Text,
HiVisWaistcoat: HiVisWaistcoat_dd.Selected,
HiVisWaistcoatQty: HiVisWaistcoatQty.Text,
LadiesFleece: LadiesFleece_dd.Selected,
LadiesFleeceQty: FemaleFleeceQty.Text,
LadiesHolsterPocketTrousersLL: LadiesHolsterTrousersLL_dd.Selected,
LadiesHolsterPocketTrousersQty: LadiesHolsterTrousersQty.Text,
LadiesHolsterPocketTrousersSize: LadiesHolsterTrousersSize_dd.Selected,
LadiesHolsterPocketTrousersWaist: LadiesHolsterTrousersWaist_dd.Selected,
LadiesOfficeTrousersLegLength: LadiesOfficeTrousersLL_dd.Selected,
LadiesOfficeTrousersQty: LadiesOfficeTrousersQty.Text,
LadiesOfficeTrousersSize: LadiesOfficeTrousersSize_dd.Selected,
LadiesOfficeTrousersWaist: LadiesOfficeTrousersWaist_dd.Selected,
LadiesPoloShirt: LadiesPoloShirt_dd.Selected,
LadiesPoloShirtQty: LadiesPoloShirtQty.Text,
MaleBerteeShortsQty: MaleBerteeShortsQty.Text,
MaleBerteeShortsWaist: MaleBerteeShortsWaist_dd.Selected,
MaleBlackOfficeTrousers: MaleBlackOfficeTrousersWaist_dd.Selected,
MaleBlackOfficeTrousersLL: MaleBlackOfficeTrousersLL_dd.Selected,
MaleBlackOfficeTrousersQty: MaleBlackOfficeTrousersQty.Text,
MaleCleanJan: MaleCleanJanWaist_dd.Selected,
MaleCleanJanLL: MaleCleanJanLL_dd.Selected,
MaleCleanJanQty: MaleCleanJanQty.Text,
MaleOxfordWhiteShirtChest: MaleOxfordWhiteShirtChest_dd.Selected,
MaleOxfordWhiteShirtNeck: MaleOxfordWhiteShirtNeck_dd.Selected,
MaleOxfordWhiteShirtQty: MaleOxfordWhiteShirt_Qty.Text,
MensFleece: MensFleece_dd.Selected,
MensFleeceQty: MensFleeceQty.Text,
MensHolsterPocketTrousersLL: MensHolsterTrousersLL_dd.Selected,
MensHolsterPocketTrousersQty: MensHolsterTrousersQty.Text,
MensHolsterTrousersWaist: MensHolsterTrousersWaist_dd.Selected,
MensPoloShirt: MensPoloShirt_dd.Selected,
MensPoloShirtQty: MensPoloShirtQty.Text,
PPEPack: PPEPack_tgl.Value,
PPEPackQty: PPEPackQty.Text,
Postcode: Postcode.Text,
ShoeBootName: ShoeBootName_dd.Selected,
ShoeBootSize: ShoeBootSize_dd.Selected,
SoftShellUnisex: SoftShellUnisex_dd.Selected,
SoftshellUnisexQty: SoftShellUnisexQty.Text,
SupMan: SupManPicker.Selected,
UnisexShortsBlack: UnisexShortsBlackWaist_dd.Selected,
UnisexShortsBlackQty: UnisexShortsBlackQty.Text,
UnisexSweatshirt: UnisexSweatshirt_dd.Selected,
UnisexSweatshirtQty: UnisexSweatshirtQty.Text,
UnisexLightweightTradesHolsterTrouserLL: UnisexTradesHolsterLL_dd.Selected,
UnisexTradesHolsterQty: UnisexTradesHolsterQty.Text,
UnisexTradesHolsterWaist: UnisexTradesHolsterWaist_dd.Selected,
UnisexWaterJackQty: UnisexWaterproofQty.Text,
UnisexWaterproofJacket: UnisexWaterproofJacket_dd.Selected,
WhiteHardHat: WhiteHardHat_dd.Selected,
WhiteHardHatQty: HardHatQty.Text,
SupMan: {
Claims: "i:0#.f|membership|" & SupManPicker.Selected.Mail,
Department: SupManPicker.Selected.Department,
DisplayName: SupManPicker.Selected.DisplayName,
Email: SupManPicker.Selected.Mail,
JobTitle:"",
Picture:""
}
);
/* THIS WILL RESET ALL FIELDS WHEN THE FORM HAS BEEN SUBMITTED */
Reset(AddressLine1);Reset(AddressLine2);Reset(Beanie_dd);Reset(BeanieQty);Reset(BumpHat_dd);Reset(BumpHatQty);Reset(CityTown);Reset(FemaleCleanJanSize_dd);Reset(FemaleCleanJanLL_dd);Reset(FemaleCleanJanQty);Reset(FemaleCleanJanWaist_dd);Reset(FemaleMascotShortsSize_dd);Reset(FemaleMascotShortsQty);Reset(FemaleOxfordWhiteShirtBust_dd);Reset(FemaleOxfordWhiteShirt_Qty);Reset(FemaleOxfordWhiteShirtSize_dd);Reset(GloveSize);Reset(GlovesQty);Reset(HiVisJacket_dd);Reset(HiVisJacketQty);Reset(HiVisWaistcoat_dd);Reset(HiVisWaistcoatQty);Reset(LadiesFleece_dd);Reset(FemaleFleeceQty);Reset(LadiesHolsterTrousersLL_dd);Reset(LadiesHolsterTrousersQty);Reset(LadiesHolsterTrousersSize_dd);Reset(LadiesHolsterTrousersWaist_dd);Reset(LadiesOfficeTrousersLL_dd);Reset(LadiesOfficeTrousersQty);Reset(LadiesOfficeTrousersSize_dd);Reset(LadiesOfficeTrousersWaist_dd);Reset(LadiesPoloShirt_dd);Reset(LadiesPoloShirtQty);Reset(MaleBerteeShortsQty);Reset(MaleBerteeShortsWaist_dd);Reset(MaleBlackOfficeTrousersWaist_dd);Reset(MaleBlackOfficeTrousersLL_dd);Reset(MaleBlackOfficeTrousersQty);Reset(MaleCleanJanWaist_dd);Reset(MaleCleanJanLL_dd);Reset(MaleCleanJanQty);Reset(MaleOxfordWhiteShirtChest_dd);Reset(MaleOxfordWhiteShirtNeck_dd);Reset(MaleOxfordWhiteShirt_Qty);Reset(MensFleece_dd);Reset(MensFleeceQty);Reset(MensHolsterTrousersLL_dd);Reset(MensHolsterTrousersQty);Reset(MensHolsterTrousersWaist_dd);Reset(MensPoloShirt_dd);Reset(MensPoloShirtQty);Reset(PPEPack_tgl);Reset(PPEPackQty);Reset(Postcode);Reset(ShoeBootName_dd);Reset(ShoeBootSize_dd);Reset(SoftShellUnisex_dd);Reset(SoftShellUnisexQty);Reset(SupManPicker);Reset(UnisexShortsBlackWaist_dd);Reset(UnisexShortsBlackQty);Reset(UnisexSweatshirt_dd);Reset(UnisexSweatshirtQty);Reset(UnisexTradesHolsterLL_dd);Reset(UnisexTradesHolsterQty);Reset(UnisexTradesHolsterWaist_dd);Reset(UnisexWaterproofQty);Reset(UnisexWaterproofJacket_dd);Reset(WhiteHardHat_dd);Reset(HardHatQty);
/* THIS WILL NAVIGATE THE USER TO THE SUCCESS SCREEN */
Navigate(Success_Scrn,Fade)
