Filtering for text within Outlook event subject that contains brackets

[KeithPowell]

I have built a flow that takes an event from Outlook and creates a planner task that is due 14 days before the event.

I would like to be able to filter the events as only certain events in my calendar require a planner task.

I have put in a filter array that searches for events that start with (M). I think the problem is that the flow expression ignores the brackets around the M.

Any ideas how I can get it to look for the (M) at the start of the event subject?

[abm · Accepted solution]

Hi @KeithPowell 

You are using the wrong action to filter the subject. The trigger only returns set of values not as a collection array.

Replace the Filter Array with a simple IF condition

Yes I agree it is odd that Filter Array returns null and shows as the step is executed successfully.

Thanks

[v-bacao-msft · Accepted solution]

Hi @KeithPowell ,

It seems that you only want to judge a single event, you could use Condition directly to judge.

The Filter array is used to filter the data whose output value is a collection, like this:

https://docs.microsoft.com/en-gb/power-automate/data-operations#use-the-filter-array-action

Hope that makes sense.

Best Regards,