Patch function is not working proprely

[Carmen15]

Hi, 

I am using Patch formula in a Edit Form, PowApps, ShP List data base. A button inserted in the form I inputted the following formula: 

Patch(UserAccessRequests , ThisItem, {'Owner': DataCardValue1.Selected , 'RequestStatus':DataCardValue9.Selected , 'Rejection Reason': DataCardValue12.Text }); Navigate(Screen2)

The formula is not patching the field Owner and I don't understand why. The column Owner is a simple choose column with a few options in the drop down list. It is strange that the Patch formula is not patching but when I am openning that specific Item in PowerApps the selection on Owner field remains selected. 

In Pow App form :

In ShP List :

[swaminawale]

Hi @Carmen15 ,

I think when you say It is strange that the Patch formula is not patching but when I am openning that specific Item in PowerApps the selection on Owner field remains selected this might happen because in your SP list choice column, default value is set (Please cross check this in column setting in SP list)

The control you are using is it Combobox or Dropdown?

Try to use 'Owner': DataCardValue1.Selected.Value. 

[Carmen15]

@swaminawale thanks for reply! 

I don't have default values set for this field. It is a COMBO BOX. 

The formula suggested by you Owner': DataCardValue1.Selected.Value  is invalid for the App (appears message that fubction Patch has invalid functionalities) . 😞 

Thanks 

Carmen 

[Nutritor_Mortem]

Is the edit form data source the SharePoint list you are attempting to patch to? If it is you could use the SubmitForm function instead of Patch

[Carmen15]

@Nutritor_Mortem I don't want to use the Submit fubction because it is creating a new Item in ShP List . I just want to patch it ( to update the item with the new changes that may appear). 

Thanks 

Carmen 

[Nutritor_Mortem]

That would indicate that the forms EditMode property is set to new rather than edit.

The SubmitForm function changes behaviour based on the Default mode of the form. If this is set to Edit, the data source is the relevant list and the Item property has a valid item from that list selected it should then be updating that item rather than creating a new item. Is there anything that is changing the DefaultMode of the form to something other than Edit?

[Sohan014]

You may try this formula and check what is the default selected value for this Owner dropdown.
formula is:

Patch(UserAccessRequests , ThisItem, {'Owner': DataCardValue1.Selected.Value , 'RequestStatus':DataCardValue9.Selected , 'Rejection Reason': DataCardValue12.Text }); Navigate(Screen2)

 

  Thanks!

[Carmen15 · Accepted solution]

@Sohan014 thanks for the reply. Actually everything is fine on the propreties or I didn't see anything that could affect the formula. 

I have resolved it on the old way 😄 .... I deleted the column from ShP list, deleted the field from the Form, re-created the column in ShP, refreshed the data base in App, added the new column. 

Now it is patching correctley. 🙂 

In the end I cannot say what was the root cause, but it has been resolved. 🙂 

Thank you all of you! 🙂