Network Error using Patch function in Canva App

[NeelamDell]

I am getting this error while trying to foster an animal.

can someone please help me with correct formula for patch.

formula I am using is on success- 

Patch('Animal tables',{'Microchip ID':'Foster Form'.LastSubmit.'Animal table','Shelter Status':'Shelter Status Choice'.'Claimed for Adoption'});

Refresh('Animal tables');

Navigate('Home Screen');

Notify("you have successfully foster an animal",NotificationType.Success)

[Aala_95]

why you used animal name as dropdown, isn't supposed to came from your home screen! meaning that when you click the animal you want to foster their (id) should be saved somewhere.

I have the same problem that I can't reflect status of the animal from "Ready for foster" to "Claim for foster)

[NeelamDell]

Thanks Aala, yes but somehow I am unable to do that logic. can anyone help? 

[BCBuizer]

Hi @NeelamDell , @Aala_95 ,

Can you please try the below?

Patch(
    'Animal tables',
    {'Microchip ID':'Foster Form'.LastSubmit.'Animal table'},
    {'Shelter Status':'Shelter Status Choice'.'Claimed for Adoption'}
);

 The reason this is more likely to work is because the second (record to update) and third (fields/values to update) arguments of the patch function are separated.

[Esraa_k]

hii @BCBuizer , The last requirement is (Ability to select an animal, enter foster family information and update the status to "claimed for foster“ on click of a button and the family that the animal is associated with) , which mean that to insert a new record in foster family table , and update the status of the selected animal from "ready for foster" to "claim for foster" in animal table. I have two questions: 1. how to update the animal status, knowing that its already shown in home screen, not in the foster screen 2. how to inert the entered data in from to foster family table. This is the code I used for insertion but its give me error: Patch('Foster Family Informations',Defaults('Foster Family Informations'),  {'Foster Claimer Name': FosterClaimerName_DataCard1.Text,     'Foster Location': FosterLocation_DataCard1.Text,     'Join Date':Joindate_DataCard1.SelectedDate} );

[TianaFash]

Hi @NeelamDell , 

How did you get the Animal Name Field to have a drop-down?  Refer to the image below: 

[NeelamDell]

@TianaFash  - I used a combo box to get the drop down for name.

[BCBuizer]

Hi @Esraa_k 

Has this issue been resolved? If so, please mark the post that was key to the solution by pressing the "Accept as Solution" button so it's easier to find for other members of the community.

Hi @TianaFash,

For questions that are not directly related to the issue for which the topic was opened, please open a new topic. Like that it is easier for other learners to find the answers in case they have similar questions.

[Grkm_A]

Hi @BCBuizer ,

I tried your solution inside of mine. But still getting the mandatory field error like @NeelamDell mentioned at first post. 

This is the ss for form:

And the update button's function is:

Patch(
    Animal_Details,
    {NewMicrochipIdentity: Form1.LastSubmit.Animal_Detail},
    {NewFosterClaimer: Form1.LastSubmit.NewFosterClaimer},
    {NewAdopter: Form1.LastSubmit.NewAdopter},
    {NewForeverFamilyStory: Form1.LastSubmit.NewForeverFamilyStory},
    {NewDateofAdoption: Form1.LastSubmit.NewDateofAdoption},
    {NewShelterStatus: 'NewShelterStatus (Animal_Details)'.'Claimed for Adoption'}
);
Notify(
    "Animal Table successfully updated",
    NotificationType.Success
);
Set(varreset,false);
Set(varreset,true);
Refresh(Animal_Details);
Navigate('AnimalList Screen')

MicrochipIdentity , Animal Name , Animal Type, Age etc inherited from the first screen to filling automatically. 

[BCBuizer]

Hi @Grkm_A ,

I see you have a little too much curly brackets in your formula, please try:

Patch(
    Animal_Details,
    {NewMicrochipIdentity: Form1.LastSubmit.Animal_Detail},
    {
        NewFosterClaimer: Form1.LastSubmit.NewFosterClaimer,
        NewAdopter: Form1.LastSubmit.NewAdopter,
        NewForeverFamilyStory: Form1.LastSubmit.NewForeverFamilyStory,
        NewDateofAdoption: Form1.LastSubmit.NewDateofAdoption,
        NewShelterStatus: 'NewShelterStatus (Animal_Details)'.'Claimed for Adoption'
    }
);
Notify(
    "Animal Table successfully updated",
    NotificationType.Success
);
Set(varreset,false);
Set(varreset,true);
Refresh(Animal_Details);
Navigate('AnimalList Screen')

You can check the documentation for the Patch function for details: Patch function (contains video) - Power Platform | Microsoft Learn