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
User | Count |
---|---|
85 | |
38 | |
23 | |
20 | |
16 |
User | Count |
---|---|
127 | |
48 | |
46 | |
27 | |
25 |