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,
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
85 | |
58 | |
49 | |
42 | |
35 |
User | Count |
---|---|
91 | |
76 | |
74 | |
60 | |
42 |