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 / Update SharePoint column
Power Apps
Answered

Update SharePoint column

(0) ShareShare
ReportReport
Posted on by 139

Hello Guys,

 

I want to update a Colum field in SharePoint when a button is selected. As a example.

Column1 has a Value "True". When user confirm button the value should be "false".

 

Is it also possible to Update the field with the Username with the User().FullName function?

 

Thanks in forward and best regards

Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @Belasor

     

    Yes it is posible, you can use Patch() function for this.

     

    To update your record you will need to put forumla similar to this in your Button.OnSelect property:

     

    Patch(
     YourSharePointList,
     Gallery1.Selected,
     {
     Column1:false,
     ColumnUser:User().FullName
     }
    )

    In Patch() function first you say which list to patch (YourSharePointList). 

    Then you specify which record in that list to patch (Gallery1.Selected), if your items are not from gallery. You can do a lookup to find the record to patch:

    Patch(
     YourSharePointList,
     LookUp(YourSharePointList,IDColumn = IdentificationVariable),
     {
     Column1:false,
     ColumnUser:User().FullName
     }
    )

    Where IDColumn is a column in SharePoint List with which you can identify records and IdentificationVariable is a variable assigned in PowerApps to match records.

     

    And then you specify which columns to change.

     

    Some notes:

    User() function can sometimes slow down your app and it is suggested to save your current user into a global variable and use through the app.

     

    To do this you would put something like this in the Screen.OnStart or OnVisible property:

     

    Set(
     _UserProfile,
     User()
    )

    Then you can just use _UserProfile.DisplayName to get the name or _UserProfile.Email to get email.

  • Belasor Profile Picture
    139 on at

    Thank you for your great answer.

     

    But I have a problem with the _UserProfile.DisplayName function. It´s also not working with

    In the SharePoint list "bookedby" is a person/group column

    I tried it with a single line column and it´s working but i would like to have this into a Person column. Is it possible?

    Thanks in forward.

     

  • v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi @Belasor,

     

    This is because that Office365Users.UserProfile(InfoAbout.Text).DisplayName is used for Office365 user connector. The user profiles need to be extracted from AzureAD, you cannot use it on SharePoint person/group column.

     

    Regards,

    Mona 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard