Answered

Updating a sharepoint column

(0) Share

Report

Posted on by Community Power Pla... 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

VisitingScreenLeavingScreen

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
skmcken 320 on at

Like (0)

Report
Copy link

Link copied!

Use the ID field of the List: -

Patch('Visitor List',
{ID:FormSelectedRecord.ID,
CheckOut:Now()})

Was this reply helpful? Yes No
Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous,

In your last screenshot try replacing "pp" with TextInput.Text
The "TextInput" is the name of the surname control on the screen.

Was this reply helpful? Yes No