Can't get a sharepoint list to update based on a flow. Please HELLLLPPP!

[zmm14]

Hello Community,

Please help me, I'm going crazy.

I can't get balances from List 2 to be updated as per an action in List 1.

1. I encounter that any person who request a leave our manager will receive it as I am the creator. 

* So I set dynamic content to Modify By Email

2. Between update item (to get the leave balances) I set a condition that Employee is equal to Modify by email.

*Not working as is not updating the balances nor sending the email with balances to leave requestor.

3. If I remove the condition all employees balances will update with the same amount

4. I will receive a total of 8 emails (all employees in our organization)

Please refer to the images.

1. 

 

2. 

3. 

4. Ended up receiving 2 emails

Please anyone, please help me on how to correct this. I have no knowledge in Powerapps or coding but I feel I have come this far and still not working.

[abm]

Hi @zmm14 

What's your Get Items step for? Are you using any filter query? 

Thanks

[zmm14]

The Get Items is to get each of the employee balances (List 2) which I wouls like to update if gets approve in my List 1 or Leave Request.

I think I'm not using a filter query.

[abm]

Hi @zmm14 

Thanks for your reply. After the Get Items you are getting the modified by.  So if you have more than one records with same modified by you will receive duplicate emails. Believe thats what happening here. What you need to do is collect the modified by unique names only. Have a look at this tutorial. Here its using the Excel sheet and in your case its SharePoint list.

https://www.youtube.com/watch?v=NaaKdgWbgTM&t=1s

[zmm14]

Hi @abm thanks you for your help really appreciate it.

Well I stop receiving 2 emails.

I still can't get to update balances in the SP list 2.

Out of my desperation I tried to I use Create item instead of using Update item then my second list appears like this.

Really I don't know what else to do.

@Pstork1 @Expiscornovus @eric-cheng 

[zmm14]

By the way I have created 2 other users with their names and email addresses and they are also receiving 3 emails with 3 different balances.