web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : bKUF/gJkipHrox4OZhQA/6
Power Apps - Building Power Apps
Answered

Problem after Patch function

Like (0) ShareShare
ReportReport
Posted on 14 Apr 2020 14:47:14 by 85

Hi everyone,

 

I'm facing a stranged situation with patch function today.

It's very simple, I have a SAVE button with patch function to edit a field in my gallery linked to sharepoint list.

For this it works fine, no problem.

The problem I have is that when I want to add another function after the patch function, like a Reset, Refresh (for the sharepoint list to show the updated field), or an Updatecontext it doesnt work.

I dont know why everything I put after the patch function is not accepted.

 

To be honest I'm kinda advanced user, I use very often 10-20 functions in a button for exemple. But Patch function is not a function I use very often, so I don't know why powerapps refuses every new function after the Patch, it looks like a syntax error but I cant explain why. If I just add a space after the patch function the editor suggest to add IN or EXACT IN only, like I was still in the patch function, but I'm sure at 100% the function is good, it works alone without any problem.

 

So I have button to save modifications in a gallery linked to a sharepoint list, after that I just want to update a variable to then disable the edit mode and come back to the view mode (its about buttons visible, displaymode, etc...):

1b.jpg

 

 

Patch('HRS Teams Naming Convention'; ThisItem; {Code:TextInput2.Text;Description:TextInput3.Text;'Code Type':Dropdown1.Selected.Value});UpdateContext({codes_dmb2:false;codes_dmb:true})

 

 

 

As you can see if I separate my functions with a ; everything after is not recognized and I receive an error saying "Unexpected characters, some characters used in this formula are unexpected).

Normally I use a "AND" or a "&" to separate my formulas, but I saw ";" on a youtube video from PowerApps 911 specially for Patch function, he used a UpdateContext after the patch function, using ; to separate formulas, and for him it worked fine, but not for me...

 

If I use AND or &, like I do for everywhere else, then the code is recognized, I have no error, but then the button doesnt work, it does nothing...

 

Thanks for your help, I'm trying to fix this since hours....

 

Any Idea ?

Categories:
I have the same question (0)
  • Nours74 Profile Picture
    85 on 14 Apr 2020 at 15:13:21
    Re: Problem after Patch function

    Thank you so much for the help, youtube and microsoft Docs never told me about that.

     

    Thanks and good day !

  • Verified answer
    eka24 Profile Picture
    20,921 on 14 Apr 2020 at 15:00:22
    Re: Problem after Patch function

    Try
    Patch('HRS Teams Naming Convention'; ThisItem; {Code:TextInput2.Text;Description:TextInput3.Text;'Code Type':Dropdown1.Selected.Value});;UpdateContext({codes_dmb2:false;codes_dmb:true})

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Verified answer
    mdevaney Profile Picture
    29,987 Moderator on 14 Apr 2020 at 14:54:34
    Re: Problem after Patch function

    @Nours74 

    You will need to use a double ;; to indicate a line-break.

     

    Patch('HRS Teams Naming Convention'; ThisItem; {Code:TextInput2.Text;Description:TextInput3.Text;'Code Type':Dropdown1.Selected.Value});;UpdateContext({codes_dmb2:false;codes_dmb:true})

     

    ---
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 885 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 571

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 352 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading complete