Compare dates

(0) Share

Report

Posted on by CU10021407-0

Good morning, I am new to flows. I have a sharepoint list with items that have a column named PM DATE. What I am trying to do is create an automated flow to compare today's date to the PM DATE column for all the items to see if todays date is 30 days or less away then send an email. I've watched quite a few videos and tried but cant seem to get the right results. So far I have:

Recurrence set up okay

Compose / convertTimeZone(utcNow(),'UTC','Eastern Standard Time','MM-dd-yyyy' )

Get Items- pulling in my sharepopint home address and correct list

This step is where i need help ....... every video says an APPLY TO EACH (this is where i need help)

I know how to send the emails in the True condition.

Categories:

Business Process Flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Tomac 3,198 Moderator on at

Like (0)

Report
Compare dates

Hi @CU10021407-0

You'll want to try this structure:

Trigger: Recurrence

Action: Get Items - targeting your SP list

Action: Apply To Each - running on the Value output from Get Items

Action: Condition

Left Side: dynamic content for PM Date from your Get Items action

Middle: less than or equal to

Right side: your convertTimeZone expression (no need to use a Compose earlier)

If Yes: Send the email and then progress to the next list item

If No: Do nothing, the flow will progress to the next list item

Was this reply helpful? Yes No
abm abm 32,617 Most Valuable Professional on at

Like (0)

Report

Compare dates

You can directly filter using Get Items with OData Filter:

PM_DATE ge '@{formatDateTime(addDays(utcNow(), -30), 'yyyy-MM-dd')}'

Was this reply helpful? Yes No
CU10021407-0 18 on at

Like (0)

Report

Compare dates

@Tomac Nothing happened.

Was this reply helpful? Yes No
CU10021407-0 18 on at

Like (0)

Report

Compare dates

@abm abm - i added that formula to the OData filter in the get items. do I still do a for each?

Was this reply helpful? Yes No