CODEWITHSUNDEEP
sharepointpower-automate
Natasha
Natasha

Reputation: 1

I set up a due date reminder in Sharepoint (MS Lists) through Power Automate, the flow is running but it doesn't recognise the dates correctly

Here is the flow:

  1. Recurrence - daily
  2. Get items - my sharepoint site and list, filter query: DueDate ge '@{utcNow()}'
  3. Filter array - From 'Get items' body/value; Filter query: and( not(empty(item()?['DueDate'])), or( equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), 7), 'yyyy-MM-dd')), equals(formatDateTime(item()?['DueDate'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), 1), 'yyyy-MM-dd')) ) )
  4. For each 2 - output from 'Get items' body/value
  5. (inside the 'For each 2" loop) - condition. expression: OR DueDate is not equal to (blank) DueDate is equal to formatDateTime(addDays(utcNow(), 7), 'yyyy-MM-dd')
    DueDate is equal to formatDateTime(addDays(utcNow(), 1), 'yyyy-MM-dd')

No actions for both True and False (loop closed) 6. Apply to each - output from 'Filter array' body 7. (inside the 'Apply to each' loop) For each - output from 'Get items' body/value 8. (inside the ' For each' loop) For each 1 - output from 'Get items' Assigned to 9. (inside the ' For each 1' loop) Send email v2.

The flow is running, but the tasks and the dates for which it sent the reminders are totally random. Apparently it doesn't pick up the dates correctly. I confirmed correctness of the column names. Could you please identify where the mistake is in this flow? Thanks in advance!

Upvotes: 0

Views: 12

Answers (0)

Related Questions