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

All responses (12)

Answers (0)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@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."
Alexyoung 36 on at

Like
a
(0)

Report
Copy link

Link copied!

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?
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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."
Alexyoung 36 on at

Like
a
(0)

Report
Copy link

Link copied!

I am trying to use it.
In the first IF statement the patch isn't working.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Alexyoung

Any error message?
Alexyoung 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Looks like something's not quite right with it
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Alexyoung

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

Like
a
(0)

Report
Copy link

Link copied!

Still not working
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Alexyoung

The close bracket ) is missing after EmployeeDataLog2.
Alexyoung 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Still having issues with it, sorry.