Hello,
I am working on a flow to email a weekly digest of a) all outstanding/not completed Planner tasks from utcNow into the past (30 days) and b) see all outstanding/not completed tasks from utcNow + 30 days.
I don't know if this can be combined into one Filter Array formula or if I need to try a different approach.
Could you advise me, please?
Here's a copy of the flow.
Solved! Go to Solution.
Hi @trishmalloy
Thank you for your posting.
According to your description, you would like to use filter array to filter three conditions (time range and task status ) and would like to know the expression. If I misunderstood, please feel free to let me know.
Since there is only one condition section in basic mode, we should switch it to advanced mode first.
|
Then, here is the target expression:
@and(greater(item()?['createdDateTime'], addDays(utcNow(), -30)),less(item()?['createdDateTime'], addDays(utcnow(),+30)),not(equals(item()?['percentComplete'], 100)))
|
|
It should work well. Please kindly test and reply me if still any problem.
Thanks.
Anna
Hi @trishmalloy
Thank you for your posting.
According to your description, you would like to use filter array to filter three conditions (time range and task status ) and would like to know the expression. If I misunderstood, please feel free to let me know.
Since there is only one condition section in basic mode, we should switch it to advanced mode first.
|
Then, here is the target expression:
@and(greater(item()?['createdDateTime'], addDays(utcNow(), -30)),less(item()?['createdDateTime'], addDays(utcnow(),+30)),not(equals(item()?['percentComplete'], 100)))
|
|
It should work well. Please kindly test and reply me if still any problem.
Thanks.
Anna
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
31 | |
30 | |
29 | |
21 | |
11 |