Patch formula

[mgreen91]

Hi,

Can someone help with what error i have in this patch formula?

Patch('Animal Information', {'Animal Information':'Foster Animal Form'.LastSubmit};

Refresh('Animal Information'); Navigate('Home Screen'); Notify( "Thank you for fostering a rescue animal!", NotificationType.Success)

[ZeeScience]

Patch('Animal Tables', {'Shelter Status': 'Shelter Status'.Form2.LastSubmit
It should look something like this

'Shelter Status' is the name of the column you want to patch (You replace it with your own column)

'Shelter Status'.Form2.LastSubmit is what it then takes from the form you submit and patches it to the Dataverse table (Form2 is the name of your own form)

[mgreen91]

Hi

I have updated but still have an error

Patch('Animal Information', {'Shelter Status':'Foster Animal Form'.LastSubmit

Refresh('Animal Information');

Navigate('Home Screen');

Notify("Thank you for fostering a rescue animal!", NotificationType.Success)

It says LastSubmit does not exist

[ZeeScience]

Are you making sure your form is set to a variable? Do you have the OnSuccess for the form with anything like the below:

Set(

    Name of Variable of Choice,

    Name of Form.LastSubmit

);

[mgreen91]

So I have set the following on the form OnSuccess variable:

Set(SignUp, 'Foster Animal Form'.LastSubmit)

And then this on the submit button:

Patch('Animal Information', {'Shelter Status':'Foster Animal Form'.LastSubmit});

Refresh('Animal Information');

Navigate('Home Screen');

Notify("Thank you for fostering a rescue animal!", NotificationType.Success)

[mgreen91]

[ZeeScience]

You did not properly close your patch function well, and also your form OnSuccess property should be where you do the setting for .LastSubmit. See my screenshot below where I used it

[ZeeScience]

the picture seems too tiny

[Corry · Accepted solution]

Hi @mgreen91,

Are you able to confirm what it is you are trying to achieve? I.e., patching a specific column or value etc?

Based on the following:

---

@mgreen91 wrote:

Hi,

Can someone help with what error i have in this patch formula?

Patch('Animal Information', {'Animal Information':'Foster Animal Form'.LastSubmit};

Refresh('Animal Information'); Navigate('Home Screen'); Notify( "Thank you for fostering a rescue animal!", NotificationType.Success)

---

and your follow up post:

So I have set the following on the form OnSuccess variable:

Set(SignUp, 'Foster Animal Form'.LastSubmit)

And then this on the submit button:

Patch('Animal Information', {'Shelter Status':'Foster Animal Form'.LastSubmit});

Refresh('Animal Information');

Navigate('Home Screen');

Notify("Thank you for fostering a rescue animal!", NotificationType.Success)

I believe you are trying to patch the Shelter Status?

From my experience, unless you are setting the shelter status within your 'Foster Animal Form', you will need to look up the specific record that was last submitted and patch the shelter status. I am doing this myself in the OnSuccess property of my form.

Patch(
    Animals,
    LookUp(
        Animals,
        cr0f4_animalsid = Form2.LastSubmit.Animals
    ),
    {
        'Shelter Status': 'Shelter Status (Animals)'.'Claimed for Foster'
    }
);
Notify(
    "Form submitted successfully",
    NotificationType.Success
)

Here is a breakdown of the formula.

Patch(

    Table Name,

    LookUp(

        Table Name,

        Unique identifier in Table = Form Name.Last Record Submited.Unique identifier Column Name

    ),

    {

        'Shelter Status': 'Choice Column Name'.'Choice'

    }

);

Notify(

    "Form submitted successfully",

    NotificationType.Success

)

SubmitForm

If your Shelter Status is a drop down (ComboBox) within your canvas app form and you can select an option. You shouldn't need to use a patch function. The SubmitForm(Form Name) formula will patch all columns (fields) that are part of your form with whatever values are selected (entered).

[J_Easter]

Hello Corry! Can you please explain how you identified the unique identifier?