Unanswered

Retrieving sharepoint list item and update that value based on another column

(0) Share

Report

Posted on by RoystonKok85

Hi Guys,

I'm new to Power Automate, just finished some online courses and trying to create a new leave tracker for my small team.

I have 2 Sharepoint list:

1) Leave Request:

2) Leave Balance

Objective:

When I create a new Leave request, e.g, John, AL Days = 2, CCL Days = 2

The flow will go to my Leave Balance sharepoint list, find John, and subtract the AL Days and CCL Days from the current number

This is my thought process. First when a new item is created or modified in Leave Request, I'll get Item from Leave Balance, and for each number of days that I've inserted into AL days and CCL days, these will be subtracted from AL and CCL (Leave Balance ) respectively.

I've tried many times but I can't seem to get the flow running. Just hoping someone can guide me to getting the flow or logic working.

Thanks in advance

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (1)

_minnies_ 91 on at

Like (0)

Report

Hi @RoystonKok85
by you can't get the flow running you meen you can't get it triggered? Is the flow activated and have you tried to use the manually test?

Best regards
Jeanine

Was this reply helpful? Yes No
RoystonKok85 14 on at

Like (0)

Report

Hi @_minnies_ , i think my flow is not complete, these i'm getting error. Either i'm using the wrong logic or inputs. I've tried testing multiple times but i cant seem to find a post similar to my circumstance.

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (0)

Report
Hi @RoystonKok85 ,

Please try this:

Overview:
"When an item is created" connects request list.
"Get items" connects balance list.

The apply to each action:
The value comes from "Get items".
The title is equal to "EmployeeName" in balance list.
The Name is equal to "requestor name" in request list.
The ID comes from "Get items".
The expression about sub:
sub(int(items('Apply_to_each')?['AL']),int(triggerOutputs()?['body/ALDays'])) sub(int(items('Apply_to_each')?['CCL']),int(triggerOutputs()?['body/CCLDays']))

Best regards,
Rimmon

Was this reply helpful? Yes No
RoystonKok85 14 on at

Like (0)

Report

Hi @v-mengmli-msft

I've hitting error on the Get Item

Thank you,
Royston

Was this reply helpful? Yes No
RoystonKok85 14 on at

Like (1)

Report

Hi @v-mengmli-msft ,

Thank you, I think i made a mistake in the Get Items (i used Get Item) instead.

Thank you,
Royston

Was this reply helpful? Yes No
RoystonKok85 14 on at

Like (0)

Report

Hi @v-mengmli-msft ,

In the condition step, i keep getting false values and am unable to trigger a true condition, thus i've not been able to proceed to the step where they subtract.

In the below screenshot, I've indicated the 2 fields which clearer shows they are the same however, the condition is still not successfully reading and comparing the 2 values.

Leave Request:
Leave Balance:
Thanks in advance.

Best Regards,
Royston

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

Hi @RoystonKok85 ,

Please check the dynamic content in condition:
They should be "Requestor name" and "EmployeeName" or "Requestor name Value" and "EmployeeName Value" instead of "Requestor name Value" and "EmployeeName".

Choice column in Dynamic Content have two formats, if you want to compare the values of two choice columns, they should be in the same format for comparison.
The "BalanceName" is the name of my choice column.

Best regards,
Rimmon

Was this reply helpful? Yes No
RoystonKok85 14 on at

Like (0)

Report

Thank you @v-mengmli-msft

Thank solved the issue!

Was this reply helpful? Yes No