Submitting Form on Canva App Creates a New Row on Dataverse Table

[TianaFash]

Hi @BCBuizer, @AhmedSalih & @mandela ,

I am currently having an issue with the Canvas app in relation to the DataVerse table. Once the form on the Canvas App is submitted, a new record is created for the fostered animal in addition to the existing row for the same animal with the ready for foster status. Please refer to the image below with the name " Blaze" describing the issue: 

I have also added a screen shot of my Canvas app.

[Rebecca-MSFT]

What formula are you using to patch/submit the information?

[mksdesign]

I am having the same issue and I am using this formula: OnSelect: SubmitForm(Foster_Form)

[AhmedSalih]

Hello, @TianaFash, The formula you are using in the OnSuccess of the EditForm is creating new record instead of update the Animal record status:

To update the Animal record status, your formula should have this format:

Patch(TableName, RecordToUpdate, {ColumnName: Value})

RecordtoUpdate can be retrevied with the lookup function: Lookup(AnimalTable, Chip#=EditFormName.LastSubmit.Chip#)

---

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

[Tiana_Fash]

Hi @AhmedSalih & @Rebecca-MSFT 

Thank you for the responses.

Please see below my patch function for the Onsucess formula for the form:

Patch(
    'Animal Details',
    {
        'Animal Detail': Form1.LastSubmit.'Animal Detail',
        'Shelter Status': 'Shelter Status (Animal Details)'.'Claimed for Foster'
    }
);
Refresh('Animal Details');
Navigate('Home Screen');
Notify(
    "You have succesfully claimed an animal to foster",
    NotificationType.Success
)

[Tiana_Fash]

Hi @AhmedSalih , 

Thank you for sharing the formula. However, it shows an error function in fx.

Inline with the names of my table and form, kindly review my formula below: 

Patch(
    'Animal Details',
    Lookup('Animal Details',Chip#=Form1.LastSubmit.Chip#),
    {shelterstatus: "claim for foster"}
);

[mandela]

Your formula seems correct so i guest your error should be with the field names, cross check the field names you referencing is correct 

[TianaFash]

Hi Mandela,

Thanks for the response.  

Which of the formulas are you referring to? I am very certain the field names aligns with the details in the Canvas App. 

[TianaFash]

Hi @AhmedSalih & @Rebecca-MSFT,

Kindly provide responses to my inquiries. I have posted two FX patch functions and would appreciate it if you could identify the right one for me to solve this. Alternatively, you can review the formula and provide feedback. 

The first formula I used : 

Patch(
    'Animal Details',
    {
        'Animal Detail': Form1.LastSubmit.'Animal Detail',
        'Shelter Status': 'Shelter Status (Animal Details)'.'Claimed for Foster'
    }
);
Refresh('Animal Details');
Navigate('Home Screen');
Notify(
    "You have succesfully claimed an animal to foster",
    NotificationType.Success
)

Based on @AhmedSalih feedback, I have revised the formula to this, however, I still get the error prompt: 

Patch(
    'Animal Details',
    Lookup('Animal Details',Chip#=Form1.LastSubmit.Chip#),
    {shelterstatus: "claim for foster"}
);

Thank you and I look forward to your response.  

[Rebecca-MSFT · Accepted solution]

Do you have time to jump on a teams call? If so send me a pm of your email address.