I am going to create a flow which collect all the event from my calendar and put it into an Excel BUT filter only for those events where the "Category" of the event is "orange".
Is it possible to filter for this information?
Without filter everything works fine, however, I was not able to add this filtering criteria.
Solved! Go to Solution.
Dear @Expiscornovus ,
still a short question to topic, if I want to extend the workflow in the future.
Is it possible to filter for 2 categories? Like for Orange and Blue one at the same time? If yes, do you have an idea how?
Thanks in advance,
I have had a look at the Filter Query, I haven't figured out a good query for that.
However, you could also try and Filter Array action with the expression below:
@and(contains(item()?['categories'], 'Blue category'), contains(item()?['categories'], 'Orange category'))
Where did you find this info?
Is there a source somewhere with the possible syntax for the odata filter on calendar?
OData is pretty common, that part I know from using it in other products. Have a look at the basics in for example Odata.org (Section 4.5 specific) https://www.odata.org/documentation/odata-version-2-0/uri-conventions/
What works or not in this specific Power Automate action is based on experience and other threads of this forum.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!