Unanswered

This is creating a log, how do I get it to update instead?

(0) Share

Report

Posted on by Alexyoung

When I run the following formula, it creates a log in my sharepoint list of all the interactions with my app:

Patch(EmployeeStatusLog,Defaults(EmployeeStatusLog),{Title:Label7.Text},{SignOut:'SignIn/SignOut'.FalseText},{Comments:TextInput1.Text},{ReturnDateTime:DatePicker1.SelectedDate},{Time:HourDropdown.Selected.Value&MinuteDropdown.Selected.Value},{Reason:Dropdown1.SelectedText});Reset(TextInput1);Reset(DatePicker1);Reset(Dropdown1);Reset(HourDropdown);Reset(MinuteDropdown);Navigate('Complete 1')

I want to create a second list 'EmployeeStatusLog2' that keeps the same line for each person and just updates as they interact with the app.

Can anyone help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

mdevaney 29,989 Moderator on at

Like (0)

Report
@Alexyoung

I dont see an employee name field in your Patch statement. For simplicity's sake lets use the employee email in this example. Its a good way to do things because its always unique

Put this code in the OnStart property of your app

// creates a new record if the employee has not logged into the app before If( IsBlank(LookUp(EmployeeStatusLog2,Email=User().Email)), Patch(EmployeeStatusLog2, Defaults(EmployeeStatusLog2), {Email: User().Email}) ) // gets the Row ID for the employee Set(employeeRowID, LookUp(EmployeeStatusLog2,Email=User().Email, ID))

When you want to update the record patch it like this (I only changed the 2nd argument).

Patch(EmployeeStatusLog, ID=employeeRowID,{Title:Label7.Text},{SignOut:'SignIn/SignOut'.FalseText},{Comments:TextInput1.Text},{ReturnDateTime:DatePicker1.SelectedDate},{Time:HourDropdown.Selected.Value&MinuteDropdown.Selected.Value},{Reason:Dropdown1.SelectedText});Reset(TextInput1);Reset(DatePicker1);Reset(Dropdown1);Reset(HourDropdown);Reset(MinuteDropdown);Navigate('Complete 1')

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

Was this reply helpful? Yes No
Alexyoung 36 on at

Like (0)

Report

Thanks for the help!

There won't be multiple people logging onto the app, it will always be logged into as the same. I use a label on the page to indicate who is signing in and out.

Is there another way?

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Alexyoung

You can still use this code. It doesn't matter how many people are using the app. It still works.

Did you try the code yet?

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

Was this reply helpful? Yes No
Alexyoung 36 on at

Like (0)

Report

I am trying to use it.
In the first IF statement the patch isn't working.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Alexyoung

Any error message?

Was this reply helpful? Yes No
Alexyoung 36 on at

Like (0)

Report

Looks like something's not quite right with it

Capture.PNG

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Alexyoung

You'll need to retype that. Some brackets are in the wrong places or are missing. Look at my code above.

Was this reply helpful? Yes No
Alexyoung 36 on at

Like (0)

Report

Still not working

Capture.PNG

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Alexyoung

The close bracket ) is missing after EmployeeDataLog2.

Was this reply helpful? Yes No
Alexyoung 36 on at

Like (0)

Report

Still having issues with it, sorry.

Capture.PNG

Was this reply helpful? Yes No