web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Reminder spams all ite...
Power Automate
Unanswered

Reminder spams all items in list

(0) ShareShare
ReportReport
Posted on by

Hi

 

I set up a flow that will send out reminders based on items in my list.

Currently there's like 15 items in this list... but the list will grow.

 

However... If a reminder is triggered now every 7 days or same day as the "start date" it will send out a reminder for EVERY item on the list (even those that are in the future)

 

Below here I give you my Flow that I somewhat copy pasted from another Flow and it might have an faulty setup in it?

 

 

Get Items

TORFS_BE_0-1714026558383.png

 

Convert time zone

TORFS_BE_1-1714026657817.png

 

Filter Array

 

TORFS_BE_2-1714026674174.png

@Or(
equals(addDays(item()?['Startdatum'], mul(int(string(coalesce(item()?['RemindMeXDaysBeforeExpire'], 9999))), -1), 'yyyy-MM-dd'), body('Convert_time_zone')),
equals(addDays(item()?['Startdatum'], -1, 'yyyy-MM-dd'), body('Convert_time_zone')),
equals(addDays(item()?['Startdatum'], -7, 'yyyy-MM-dd'), body('Convert_time_zone'))
)

 

Apply to each

 

TORFS_BE_3-1714026726555.png

 

 

Thank you!

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    on at
    Re: Reminder spams all items in list

    Hi @TORFS_BE ,

     

    It seems that you have mistakenly selected values from dynamic contents.

    vjefferni_0-1714027504805.png

     

    There shouldn't be the apply to each 2, you should write expressions to get values from Filter array outputs. Please copy the Message of Post message action and paste on a notebook and change "Apply_to_each_2" to "Apply_to_each", delete the body, drag the action out of apply to each 2 and place it in apply to each control, copy codes from notebook and paste to Message.

     

    Best regards,

  • TORFS_BE Profile Picture
    on at
    Re: Reminder spams all items in list

    Hi @v-jefferni 

     

    Thanks for the reply.

    First of all, i'm not an expert with this so.... 

    I tried to follow the steps as suggested but i'm not able to drag  "Post message in a chat or channel"  out of "Apply to each 2" as I get an error message im not allowed as it depends on an action inside foreach.

     

    Are you able to guide me a bit more into detail please? 

    Thank you!

     

  • v-jefferni Profile Picture
    on at
    Re: Reminder spams all items in list

    Hi @TORFS_BE ,

     

    You need to follow the steps one by one. After deleting everything in the Message, the action can drag and drop.

     

    Best regards,

  • TORFS_BE Profile Picture
    on at
    Re: Reminder spams all items in list

    Hi @v-jefferni 

     

    Ok, I did as you told me and it seems to be working properly now.

     

    thank you for your assistance 🙂

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard