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?
Solved! Go to 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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials
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,
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials
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,
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
36 | |
36 | |
23 |
User | Count |
---|---|
41 | |
31 | |
29 | |
28 | |
26 |