Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 1qf8yDyIU7M9aBmA1h1RPb
Power Apps - Building Power Apps
Answered

Patch new record and update existing record

Like (0) ShareShare
ReportReport
Posted on 21 Aug 2020 01:46:37 by

Hi everyone.

 

I have a SharePoint list to check if a person submit a form on which category (product/competitor product/manager verification).

 

shabilass_0-1597973412168.png

Whenever user submit a form (this form will store the record in another list, not in this list), PowerApps will check whether the form is submitted under which category and update "1" in this list (above picture). I have made dropdown list to determine this category that have 3 choice (product/competitor product/manager verification).

 

I tried used below patch function, but it creates new record instead of update the column inthe existing record (refer to sarah's record in the picture).

 

If(DataCardValue3.Selected.Value = "Competitor",
   Patch('List Name',
         Defaults('List Name'),
             {
                Title: DataCardValue7.Text,
                Month: DataCardValue4.Text,
                Year: DataCardValue12.Text,
                'Competitor Product': "1"

}));

If(DataCardValue3.Selected.Value = "Our products",
   Patch('List Name',
         Defaults('List Name'),
         {     Title: DataCardValue7.Text,
               Month: DataCardValue4.Text,
               Year: DataCardValue12.Text,
              'Product': "1"

}));

 

How can I capture whether user submit new record or already have existing record? I know I cannot used the "defaults" on both patch, but don't know how to start.

 

If new record, it will patch and create new record.

If existing record, it will patch/update the column in existing record.

 

Thank you in advance!

Categories:
  • Jira Profile Picture
    69 on 23 Jun 2021 at 02:12:46
    Re: Patch new record and update existing record

    Thanks for your replied even my issue was resolved, i remove my workflow and recreate it.  Then this problem resolved.

  • Community Power Platform Member Profile Picture
    on 16 Jun 2021 at 11:24:05
    Re: Patch new record and update existing record

    @Jira 

    I see that's almost two months after your post, but i've experienced the same issue. I resolved it as followed

     

    Lookup('DataSource',Title=DataCardValue2.Text)

     

    Kind regards

  • Jira Profile Picture
    69 on 14 Apr 2021 at 03:30:48
    Re: Patch new record and update existing record

    I'm newbies for PowerApps, please advice.

     

    I follow your solution above on my app, I found error when type LookUp(Title:DataCardValue2.Text) same as your. 

     

    Here are my questions:

    1. why my code below shown error while your sample code did not?  

    error2.jpg

    2. Refer to above reference, LookUp usually follow with source.  is this exceptional case that no data source required?

     

    3. when I insert my data source, I still found error also.

    error.jpg

     

    please advice, thank you

  • Community Power Platform Member Profile Picture
    on 21 Aug 2020 at 03:27:30
    Re: Patch new record and update existing record

    Hi @mdevaney 

    Thank you for the reply! It works very well!

  • Verified answer
    mdevaney Profile Picture
    29,987 Super User 2025 Season 1 on 21 Aug 2020 at 02:21:55
    Re: Patch new record and update existing record

    @Anonymous 

    My code below will show you how its done.  You can apply a similar concept to your other code segment.

    // try to find the record and store it in a variable if it exists
    Set(lookupRecord, LookUp(Title: DataCardValue7.Text, Month: DataCardValue4.Text, Year: DataCardValue12.Text,));
    
    If(
     // if no record exists create a new one
     DataCardValue3.Selected.Value = "Competitor" And IsBlank(lookupRecord),
     Patch(
     'List Name',
     Defaults('List Name'),
     {
     Title: DataCardValue7.Text,
     Month: DataCardValue4.Text,
     Year: DataCardValue12.Text,
     'Competitor Product': "1"
     }
     ),
    
     //if the record exists update instead
     DataCardValue3.Selected.Value = "Competitor" And IsBlank(lookupRecord),
     Patch('List Name', lookupRecord, 'Competitor Product': "1")
    );

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 10

#2
LC-26081402-0 Profile Picture

LC-26081402-0 6

#3
EE-04041031-0 Profile Picture

EE-04041031-0 4

Overall leaderboard