Updating fields only based on successful submission.

[Kirsten2]

I have a last screen, which is a successful submission for an order. I want to update three status fields based on a successful submission and update the field for date of submission to a SharePoint List.

I am trying to do this by having a form control that's invisible for those fields where I put the following for the "OnSuccess" property:

Actual Code:

Patch(Orders,LookUp(Orders,'Order ID'=DataCardValue208.Text),{'Initial Date': Today(),'Equipment Status': "Inquiry Received",'Support Status': "Identified", Status: "In-progress"})

Orders is the SharePointList and DataCardValue208 is the value for the Order ID listed in the form.

Error:

The type of this argument 'Equipment Status' does not match the expected type 'Record'. Found type 'Text'.

The function 'Patch' has some invalid arguments. 

[WarrenBelz]

Hi @Kirsten2 ,

Assuming 'Equipment Status' is a Choice field, you should need

Patch(
   Orders,
   {ID: Self.LastSubmit.ID},
   {
      'Initial Date': Today(),
      'Equipment Status': {Value: "Inquiry Received"},
      'Support Status': "Identified", 
      Status: "In-progress"
   }
)

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

[Kirsten2]

Thanks! They are all choice fields, except for the Initial Date. I tried the following:

Patch(Orders,{ID: Self.LastSubmit.ID},{'Initial Date': Today(),'Equipment Status'.Value: "Inquiry Received",'Support Status'.Value: "Identified", Status.Value: "In-progress"})

Error: 

Expected operator. We expect an operator such as +,*, or & at this point in the formula.

The function 'Patch' has some invalid arguments. 

What does {ID: Self.LastSubmit.ID} do? What does ID mean in the two different references there? Just curious for my understanding. 

[Kirsten2]

Since I am having difficulties with this approach, I was thinking of setting the default values in the form, stead of the patch function. However, I am having trouble with that as well. 

For the Default value, I tried the following, for example:

"In-progress"

Error:  Expected Record value.

[WarrenBelz · Accepted solution]

Hi @Kirsten2 ,

Try this

Patch(
   Orders,
   {ID: Self.LastSubmit.ID},
   {
      'Initial Date': Today(),
      'Equipment Status': {Value: "Inquiry Received"},
      'Support Status': {Value: "Identified"}, 
      Status: {Value: "In-progress"}
   }
)

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

[Kirsten2]

Thanks! I no longer get errors with the above code, but when I test it out by clicking the submit button, I do not get any updates to the underlying SharePoint List. I have never tried the "OnSuccess" property before, so perhaps I am doing something wrong. I have no requirements set yet and I just have a navigation function for the "OnSelect" for the submit button. Do I need to add something to the submit button to connect it to the "OnSuccess" property of the form? Is there something I am missing?

[WarrenBelz]

Hi @Kirsten2 ,

Have you properly refreshed your SharePoint list - that is fairly basic Patch code (which must have valid values or you would be getting errors) and simply should update the same record as was submitted in the Form with the values specified.

[Kirsten2]

I refreshed several times and tried submitting several times. 

[Kirsten2]

I decided to test out the same code by copying and pasting it into the "OnSelect" of the submit button to see if it works there. I got an error there with the code.

Error: 

The type of this argument 'ID' does not match the expected type 'Number'. Found type 'Error'.

Name isn't valid. 'LastSubmit' isn't recognized.

The function 'Patch' has some invalid arguments.

[WarrenBelz]

@Kirsten2 .

Makes no sense presently - put this on the end and see if your get the notification

Patch(
   Orders,
   {ID: Self.LastSubmit.ID},
   {
      'Initial Date': Today(),
      'Equipment Status': {Value: "Inquiry Received"},
      'Support Status': {Value: "Identified"}, 
      Status: {Value: "In-progress"}
   }
);
Notify("Patched !!", NotificationType.Success)