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 / Updating a sharepoint ...
Power Apps
Answered

Updating a sharepoint column

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi all, 

I try to create a visitor management application. 
I created 4 screens :
-Welcome screen (visitor clicks on "visiting" or leaving")
-Visitingscreen (visitor fills in fields and clicks on submit to create an item on a sharepoint list (VisitorList))
-Leavingscreen (visitor fills in Surname field and clicks on submit to update a column (CheckOut DateTime)
-Thanks screen

VisitingScreenVisitingScreenLeavingScreenLeavingScreen

I don't know how to write the formula for the submit button on the LeavingPage. The Surname should match with the surname on the sharepoint list and update the right column. 

Could someone help me ? 

Thanks !!

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

    Up. 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I wrote this function for my Submit button. I would like to replace "pp" by the surname field but it doesn't accept. 

     

     

     

    powerapps3.PNG

  • skmcken Profile Picture
    320 on at

    Use the ID field of the List: - 

     

    Patch('Visitor List',

    {ID:FormSelectedRecord.ID,

    CheckOut:Now()})

  • Verified answer
    Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

    @Anonymous,

     

    In your last screenshot try replacing "pp" with TextInput.Text

    The "TextInput" is the name of the surname control on the screen.

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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard