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.
on:
Need enhancements to make Sharing flows easier
on:
Allow Condition Action BEFORE trigger instead of a...
on:
[Approval] - Cancel Approval on Power Automate
on:
Give the option to suppress Flow Checker Warnings
This work has been completed. You can read more about it here: https://flow.microsoft.com/blog/nested-apply-to-each/