cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Email tracking with a Sharepoint List

Hi, 

 

In my MS flow I need to track the number of email notifications that are sent when an item is delayed to the creator of the item .

 

I want to track if the email was sent already for the particular delayed item, and if the email was already sent I want to skip it.

This is what I have thus far:

2020-06-26 14_14_52-Window.png

2020-06-26 14_19_27-Window.png

2020-06-26 14_24_45-Window.png

 

 

However, when I test this out, it stops at the condition at the Apply to each 3 step:

 

2020-06-26 13_55_47-Power Apps.png

 

This is the exact formula that I have in the condition step:

2020-06-26 14_29_17-Window.png

 

empty(body('Filter_array_2')?['value'])

 

Please let me know if this is incorrect, or if there is a better way of doing this. Thank you!

 

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Email tracking with a Sharepoint List

Hi @imadorkous 

 

It's difficult to see what's going wrong without seeing the data. I could look into this via a screen share if required. Another way to think is add a column called Email Send Yes/No. Filter the list where email send is Yes. Also one the email is sent then update the list column to Yes.

 

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

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (9,761)