Power Platform Community Forum Thread Details

First I will show you what we already got and where we want to go.

I've created a contract tracker that will spit out reminders 7, 30, 60 and 90 days before the date will expire.

Additional I can let them set a custom day to spit out an extra reminder AND an extra column to send out the reminder to an extra e-mail.

Here my current flow in detail;

Filter array detail;

@OR(
equals(addDays(item()?['Vervaldatum'], mul(int(string(coalesce(item()?['RemindMeXDaysBeforeExpire'], 9999))), -1), 'yyyy-MM-dd'), body('Convert_time_zone')),
equals(addDays(item()?['Vervaldatum'], -7, 'yyyy-MM-dd'), body('Convert_time_zone')),
equals(addDays(item()?['Vervaldatum'], -30, 'yyyy-MM-dd'), body('Convert_time_zone')),
equals(addDays(item()?['Vervaldatum'], -60, 'yyyy-MM-dd'), body('Convert_time_zone')),
equals(addDays(item()?['Vervaldatum'], -90, 'yyyy-MM-dd'), body('Convert_time_zone'))
)

Ok what we want to accomplish now;

-----------------------------------------

Extra column to be added:

*Einde triennaat

In the column "startdatum" they will always insert a start date of the contract

In the column "einde triennaat" they want a reminder 7 AND 9 months based on "Startdatum"

In the column "einde contract" every 16 and 18 months based on "Startdatum"

So, reminders based on two different columns to gather their info.

I don't really wanna lose my previous setup so is there a way to make the system that smart so it will lookup under which folder the documents are placed?

Here is my folder setup;

I have contracts of specific departments and the things i'm asking would apply for documents under "Huur".

All the other reminder can apply for the other folders. not for "Huur" as they want the custom ones as listed above.