cancel
Showing results for 
Search instead for 
Did you mean: 

Be able to handle CurrentTime and Current Date in Condition Block

Current MicrosoftFlows version is great, since it recently added the possibility to read Excel rows, filter them with Condition Block and execute an action for each row matching the condition.

However it will be even greater if we could add a Condition based on current Date / current Time, meaning Execution Date & Time.

Imagine we have an Excel Table with items borrowed by teammates; so we have Borrowers email address, Borrowing Date, and also Expiration Date.

With current Microsoft Flows, we can define a daily flow that gets the Excel table, select registers matching a condition, and send a reminder email to each of them. However, since MicrosoftFlows does not support Excel Tables with formulas, we need the Condition Block to evaluate if Expiration date has elapsed, based on Execution Date.

Status: Completed

This work has been completed. You can read more about it here: https://flow.microsoft.com/blog/nested-apply-to-each/

Comments
Level 8
Flow Staff
Status changed to: Planned
 
Level: Power Up

Thanks for the post efialtes and the workaround link you shaerd as it worked for me.

Flow Staff
Status changed to: Started
 
Flow Staff
Status changed to: Completed

This work has been completed. You can read more about it here: https://flow.microsoft.com/blog/nested-apply-to-each/