Update a field with a variable using Patch not working

[jms345]

I have a main gallery screen showing name and Status of Application (in this example, "New":

On clicking EDIT, I set a variable varRecord and navigate to the first processing screen: 

 Set(varRecord,ThisItem);Select(Parent);Navigate(Process); EditForm(Form1)

The Process screen shows all record details from my Sharepoint List in Form1, along with a COMMIT CHANGES button to allow edited changes to be saved:

SubmitForm(Form1)

So far so good!  However, as the process goes on, I want to use a dropdown to choose the different stages (New, Invitation, Offer, Confirmed).  On the same screen, I added the dropdown and tried writing these to a variable on CHANGE in the dropdown:

Set(varStatus,Dropdown2.Selected.Name)

and then have Form1's Status field updated by using PATCH: 

Patch(varRecord, {Status:varStatus})

but it doesn't work.

Note: The different screens from the navigation dropdown (Invitation, Offer etc.) each shows an HTMLbox with different letters to send out, so the varStatus variable should be updated on a button from each of these screens.

(Originally I had Status field in my list as a CHOICE field, but it seemed that the SUBMITFORM command would update Text fields, but not CHOICE fields, so I converted the LIST settings to make it a text field.)

Can anyone give me ideas how to get past this blocker?  Many thanks in advance.

[WarrenBelz]

Hi @jms345 ,

This should work

Set(
   varRecord,
   Patch(
      varRecord,
      {Status: varStatus}
   )
)

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

[jms345]

Many thanks for your reply.  I pasted your suggestion and the form shows it has updated varRecord.Status with the correct value of varStatus, however the Status field in my list is then wiped blank for some reason.  Could it be related to the fact I had changed the STATUS choice field to a text field?  Should I have created a new Status field as text?

[jms345]

I am still having problems so went back to my Sharepoint list and changed the Status field back to a CHOICES type field.  The process should be:

STATUS field is shown

On clicking EDIT I run this code: Set(varRecord,ThisItem);Select(Parent);Navigate(Process); EditForm(Form1)

The Status field is a combobox (DatacardValue3) - on CHANGE I want it to update the Sharepoint list:

Set(varStatus,DataCardValue3.Selected.Value);
Patch(varRecord,
{Status: varStatus}
)

At first it was writing a blank record as varStatus was not being set.  I added SET(varStatus) then Patch came up with an error.  Can you see my error??  

Many thanks in anticipation! - John

[jms345]

I now found I get rid of the error if I type PATCH(varRecord.Status, {Status: varStatus}) - but it still for some reason changes the value of varStatus to blank and clears the field.  

[jms345]

partly solved - I found if I change the patch code on CHANGE event to this:

Patch('School Application Form',
varRecord, {Status: {Value: DataCardValue3.Selected.Value}
})

it does update the record.  However, it continues to show the "updating" scrolling dots even if I switch screens or stop previewing the app.  It seems like the update is in an infinite loop.  I tried error handling with NOTIFY but it doesn't show an error.  I also tried adding a setfocus to move on but no success!

[WarrenBelz]

Hi @jms345 ,

If Status is a Choice field

Set(
   varRecord,
   Patch(
      varRecord,
      {Status: {Value: DataCardValue3.Selected.Value}}
   )
)

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

[jms345]

Hi again - I copied the code

Set(varRecord,

Patch(

          varRecord,

                          {Status: {Value: DataCardValue3.Selected.Value}}

     )

)

into the On Change property - it is in a form on the second screen ("Process").  It doesn't update the sharepoint list for some reason.  As I mentioned, it does if I add the list data source -

Patch( 'School Application Form', {Status: {Value: DataCardValue3.Selected.Value}} ), but I now found the error says "Network Error using patch: Field Title must be used"

[jms345]

I meant "Title is required" - I edited this in list settings to make it not required, but I now get a different network error.

Confused/.....

[WarrenBelz]

@jms345 ,

This is a different matter to your posted question as until now, we have been dealing with updating a Variable - you were using SubmitForm to update your SharePoint list. Is the variable now working ?