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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Basic Patch function n...
Power Apps
Answered

Basic Patch function not working as expected

(0) ShareShare
ReportReport
Posted on by 69

Hi,

 

I need to get the current logged in users email address patched to my sharepoint list however I cant seem to get it working, please can someone advise:

 

The sharepoint list is called: New_Starter

The field in my list is a single line of text called 'Submitted By'

 

I have created a button in my Powerapp screen which also has the New_Starter sharepoint form loaded in edit mode.

 

OnSelect code for the button is: 

 

Patch(New_Starter,{'Submitted By':User().email}

 

Any reason why this won't work?

Categories:
  • Verified answer
    mdevaney Profile Picture
    29,993 Moderator on at

    @snipesnab 
    You are missing the 2nd parameter of the PATCH function which tells it to either create a new row or update an existing row.  Which one are you trying to do here?

     

    I wrote an article on how to patch every SharePoint column type if you find it helpful.

    https://matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/

     

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

  • snipesnab Profile Picture
    69 on at

    Hi, updating an existing row on the current record

     

    I have tried this updated code but still not working:

     

    Patch(New_Starter,frm_Finalise.LastSubmit,{'Submitted By': User().Email})

  • snipesnab Profile Picture
    69 on at

    Thanks for you input - I have it working now as per code above. Needed to refresh connector!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard