Answered

Leave Balance with List sharepoint

(0) Share

Report

Posted on by donladski

Hi I am currently working in our company the LMS.

I have a question, what code can I set this two list ( LeaveTypes and Leave Request)
Leave request has a choices of LeaveType and also my LeaveTypes List has the same column. Is there any possible if Leave Request Leave type trigger the LeaveTypes List to send data and minus the available leave??

Thank you!

I hope you get me in my explanation.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

fratrucc 86 on at

Like
a
(0)

Report
Copy link

Link copied!

@donladski Do you just want to show how many hours are avaible after one user pick the leave type?
In this scenario, i'll try to work with the "on change" function avaible for a dropdown (where users chose the leave type) or with the "OnCheck" and "OnUnCheck" avaible for checkbox. In this properties i'll put a lookup, filtered with data that the user already wrote, that change a variable and you can show it in a label.

Was this reply helpful? Yes No
donladski 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi I think thats the scenerio I want,

I want to trigger the sharepoint List I created which is the LeaveType List. Do you have any tutorial? Like youtube or blogs that I can read? I am new in PowerApps no idea about the coding.

Please also see my Leave Choices which I used is Leave Request List in sharepoint

Was this reply helpful? Yes No
donladski 19 on at

Like
a
(0)

Report
Copy link

Link copied!

@fratrucc hoping you help me in my scenerio.. I hope you understand what Im saying hehehe im bad in explaining.

THank you

Was this reply helpful? Yes No
Verified answer

fratrucc 86 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, i was trying to figured it out, i normally don't use checkbox.
Checkbox1 - OnCheck

Spoiler (Highlight to read)
Set(
varCheckbox,
ThisItem.Value
);
Set(
varSelected,
(LookUp(
results,
(Title = varCheckbox)
))
)

Set(varCheckbox,ThisItem.Value);Set(varSelected,(LookUp(results,(Title = varCheckbox))))

Checkbox1 - OnUncheck
Set(varCheckbox, "")

labelShowLeftHours - text
Text(varSelected.Title &": "& varSelected.'Choice 2'.Value &" hours left")

I get from list A (name Checklist) the option for the checkbox in the gallery.
List B (name results) is like that
So, this was just an example, hope it helps.
Francesco

Was this reply helpful? Yes No