Answered

Reminder spams all items in list

(0) Share

Report

Posted on by TORFS_BE

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

Convert time zone

Filter Array

@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

Thank you!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TORFS_BE ,

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

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,

Was this reply helpful? Yes No
TORFS_BE on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
TORFS_BE on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni

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

thank you for your assistance 🙂

Was this reply helpful? Yes No