Power Platform Community Forum Thread Details

Goal:
- To update data taken from the DataCardValue in Powerapps inside a Sharepoint List by adding to the concurrent amount.

- Making sure that it is linked to the correct Leave Type and correct Name

Issue:

- I can create a new data but I can't update the current one the person is entitled to.

- I don't know how to make it link so that it captures the person's data correctly in order to update their specific record.

Concurrent Code in Use:

UpdateIf('EMP Leave Quota', DataCardValue15.Selected.Value= "Medical" , {Used:Value(DataCardValue24.Text)});

Old Testing Code (Would prefer to use this instead):

If(
 DataCardValue15.Selected.Value= "Medical",
 Patch(
 'EMP Leave Quota',
 {Used:Value(DataCardValue24.Text)}
 ),
 DataCardValue15.Selected.Value= "Maternity",
 Patch(
 'EMP Leave Quota',
 {Used:Value(DataCardValue24.Text)}
 ),
 Patch(
 'EMP Leave Quota',
 {Used:Value(DataCardValue24.Text)}
 )
);

The first one is to update where the 'Leave Type' is equivalent to Medical Leave
Second one is for Maternity, which will be deducted from Maternity Leave

Third one is for the 2 who does not fall under that category that will be deducted from Annual Leave type

Categories:

Building Power Apps

Hi @gimar01 ,

So would you like to update the Used value to "EMP Leave Quota" list, depending on employee number/name and leave type?

If so, as per your screenshots, assuming that Leave Type is a Choice type (EDIT: Allow Single Selection) column and Employee No is a Text type column, you could modify the testing code to:

If(
 DataCardValue15.Selected.Value= "Medical",
 Patch(
 'EMP Leave Quota',
 LookUp(Filter('EMP Leave Quota','Leave Type'.Value = "Medical Leave"),'Employee No' = EmployeeNoDataCardValue.Text),
 {Used:Value(DataCardValue24.Text)}
 ),
 DataCardValue15.Selected.Value= "Maternity",
 Patch(
 'EMP Leave Quota',
 LookUp(Filter('EMP Leave Quota','Leave Type'.Value = "Maternity Leave"),'Employee No' = EmployeeNoDataCardValue.Text),
 {Used:Value(DataCardValue24.Text)}
 ),
 Patch(
 'EMP Leave Quota',
 LookUp(Filter('EMP Leave Quota','Leave Type'.Value = "Annual Leave"),'Employee No' = EmployeeNoDataCardValue.Text),
 {Used:Value(DataCardValue24.Text)}
 )
);

Please have a try, and if have any question you could leave it here.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.