Formula help

[trishmalloy]

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.

[v-duann-msft · Accepted 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