Adding different number of days

(0) Share

Report

Posted on by MarcoS4

Hello All

I am totally new to Power Automate and need some help please.

I have created a contract management system using sharepoint list and created a flow to remind users 30 days in advance of the "termination date". This works using this expression

formatDateTime(addDays(utcNow(),30),'yyyy-MM-dd')

Some contracts need to be negotiated 30,60,90.....days before termination date. I have added a column "Termination Notice" to my sharepoint list which contains the number of days prior to the termination date that the notification must go out but my question is, how do i get my flow to recognize that it needs to send the notification either 30,60,90.... days before the termination date?

I hope this makes sense.

Thanks

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

MarcoS4 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you wskinnermctc,

This worked for me. The only change was to put 'AND' in all lowercase.

Much appreciated

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!
You just need to combine the filter using AND OR and wrap each in parentheses ().

(Statement AND statement) OR (Statment2 AND Statement2)

If your TerminationNotice is a number type column then the number is by itself without ' single ' quotes:

(TerminationDate eq 'formatDateTime(addDays(utcNow(),30),'yyyy-MM-dd')' AND TerminationNotice eq 30) OR (TerminationDate eq 'formatDateTime(addDays(utcNow(),60),'yyyy-MM-dd')' AND TerminationNotice eq 60) OR (TerminationDate eq 'formatDateTime(addDays(utcNow(),90),'yyyy-MM-dd')' AND TerminationNotice eq 90)

If your TerminationNotice column is a single line text then the numbers need ' single ' quotes:

(TerminationDate eq 'formatDateTime(addDays(utcNow(),30),'yyyy-MM-dd')' AND TerminationNotice eq '30') OR (TerminationDate eq 'formatDateTime(addDays(utcNow(),60),'yyyy-MM-dd')' AND TerminationNotice eq '60') OR (TerminationDate eq 'formatDateTime(addDays(utcNow(),90),'yyyy-MM-dd')' AND TerminationNotice eq '90')

Try this in your Filtery Query.

Just make sure the spaces are correct and doesn't use line breaks.

Was this reply helpful? Yes No