cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zmm14
Helper III
Helper III

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

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. 

zmm14_0-1634800741136.png 

2. 

zmm14_1-1634800828769.png

3. 

zmm14_3-1634801151606.png

 

4. Ended up receiving 2 emails

zmm14_4-1634801190699.png

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.

 

 

5 REPLIES 5
abm
Super User
Super User

Hi @zmm14 

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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.

 

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

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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.

zmm14_0-1634933435779.png

Really I don't know what else to do.

@Pstork1 @Expiscornovus @eric-cheng 

zmm14
Helper III
Helper III

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,664)