Planner Array Filter

(0) Share

Report

Posted on by Tewkes

Hi,

Would apprechaite any help with this.

Im using the follwoing template "Click a button for a tutorial to send an HTML Email for Planner Reporting Click a button for a tutorial to send an HTML Email for Planner Reporting "Click a button for a tutorial to send an HTML Email for Planner Reporting"

Want to be able to filter out tasks that are completed. Pretty new to Power Automate so im not sure where or how the array filter needs to be applied.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

Hi @Tewkes,

You could add a filter array to the flow and check if the percentage complete doesn't equal 100%.

Below is an example setup.

1. Add Filter Array action to the flow. Directly after List tasks. Make sure you use the value field in the from and the value Percent Complete in the filter condition.

2. Replace the value field of the Lists tasks by the Body field of the Filter Array in Select an output from previous steps field of the Apply to Each action.

This way it will only use your filtered items.

3. Replace other fields in the Get Task Details and Append to string variable the html table rows actions so it is using the Filter Array fields instead of the List Task fields.

Was this reply helpful? Yes No
Tewkes 10 on at

Like (1)

Report

Thank you for the feedback.

All sorted.

Was this reply helpful? Yes No