SubmitForm(Form1) - Suddenly not working!

[StacyO]

I have a new app I deployed and the submit function is no longer working.  I am using a button that sets 4 simple variables then SubmitForm.  In the OnSuccess property I am trying to Patch the Title field using a variable and the LastSubmit function. It worked when I completed testing a few weeks ago and now it is not. Here are my settings:

OnSelect for Button:  

SubmitForm(RequestForm);

OnSuccess for RequestForm

Set(

   varRequest,RequestForm.LastSubmit);

Set(

    FullName,

    varRequest.'Hiring Manager'.DisplayName

);

Set(

    LastName,

    First(

        Split(

            FullName,

            " (US),"

        )

    )

);

Set(

    varTitle,

    txtSJC.Value & " | " & LastName.Value

);

Patch(

    'Requisitions', RequestForm.LastSubmit,

    {Title: varTitle}, 

    {HiringMgrtxt: varRequest.'Hiring Manager'.DisplayName}

);

Any thoughts on what this could be?  I've ran the monitor and it seems to be in the patching.  Any help is greatly appreciated.

[WarrenBelz · Accepted solution]

Hi @StacyO ,

Firstly try this OnSuccess - I assume the Patch is working

With(
   {
      _Title:
      First(
         Split(
            Self.LastSubmit.'Hiring Manager'.DisplayName,
            " (US),"
         )
      ).Value
   },
   Patch(
      'Requisitions', 
      {
         ID: Self.LastSubmit.ID,
         Title: _Title, 
         HiringMgrtxt: Self.LastSubmit.'Hiring Manager'.DisplayName
      }
   )
);

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[StacyO]

Thanks Warren.  While I was waiting for a response, I went to my app and removed the patch function all together.  The submit button does nothing now??? I also created an whole new submit button and that doesn't work either. Is it something with the Form Mode?

[swaminawale]

Hi @StacyO ,

The code you gave looks good and could you please specify what error you are facing so that we can provide you a solution like error in fields or something else.

[StacyO]

wondering if my form is broken and I need to rebuild it?

[swaminawale]

What's the backend here? Sharepoint or Dataverse?

Have you changed any column name or deleted any column which you are using earlier.... In this case you might face some issues.

If possible then can you please share a screenshot of error you are facing?

[StacyO]

datasource is sharepoint list...only thing I did was change a choice field from single select to multi select.  Not seeing any issues with that.  How can I grab the error? I'm using monitor ...here is a screenshot of that:

[StacyO]

more details on "Error 9"????

[WarrenBelz]

Hi @StacyO ,

You need to re-generate the Data Card for that Choice field) (delete it from the Form and open again) for that control and let Power Apps take care of it properly. SubmitForm and OnSuccess should take care of it.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[StacyO]

Only other recent change is that I granted a bunch of permissions