Answered

update(deduct based of an existing datacard) a column in another list based of user name

(0) Share

Report

Posted on by GTurkistane

114

i have 2 sharepoint lists one is called Leave Requests and the other is Employees, i have an edit form that is connected to "Leave requests" and i want the form upon success to take a number from a datacard in the edit form and deduct that value from a column called "Vacation Days Count" in "Employees"(it has only 2 columns "Employee Name", "Vacation Days Count"), the row that it will deduct from, will be based of the username, here is what i got:

If(DataCardValue3.Selected.Value = "Approved",

Patch('Employees', 


LookUp(Employees, 


'Employee Name'.DisplayName = User().FullName,


{'Vacation Days Count': 20}
)));

how ever this formula instead of changing an existing record, it adds a new one without a name and a count of 20(i put a random number because i do not know who i can make it read the existing number and deduct form it)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

AARON_C 2,235 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @GTurkistane

Please try this:

If(DataCardValue3.Selected.Value = "Approved", Patch('Employees', LookUp(Employees, 'Employee Name'.DisplayName = User().FullName), { 'Vacation Days Count': 20 } ) );

I have moved the closing bracket of the lookup function.

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
GTurkistane 114 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you it worked, do you know i can get the current count and then deduct from it?

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@GTurkistane

Try this:
If(DataCardValue3.Selected.Value = "Approved", Patch('Employees', LookUp(Employees, 'Employee Name'.DisplayName = User().FullName), { 'Vacation Days Count': LookUp(Employees, 'Employee Name'.DisplayName = User().FullName).'Vacation Days Count' - Value(TextInput1.Text) // Where TextInput1 would be the amount of days a user would enter } ) );

Was this reply helpful? Yes No
GTurkistane 114 on at

Like
a
(0)

Report
Copy link

Link copied!

you are amazing, thank you so much it worked

Was this reply helpful? Yes No