cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bakaidora
Regular Visitor

Get calendar view of events (V3) - Filter Query

Hello together,

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.

Please advice!

Thanks,

Dóra

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @bakaidora,

 

You could try a filter query like below. Be aware, the name of the category is case sensitive!

 

 

categories/any(c:c+eq+'Orange category')

 

 

getorangecategory_filterquery.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

6 REPLIES 6
Expiscornovus
Super User
Super User

Hi @bakaidora,

 

You could try a filter query like below. Be aware, the name of the category is case sensitive!

 

 

categories/any(c:c+eq+'Orange category')

 

 

getorangecategory_filterquery.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


bakaidora
Regular Visitor

Dear @Expiscornovus 

thanks for your help, this is the perfect solution for my issue. 🙂

Have a nice day.

Dóra

bakaidora
Regular Visitor

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,

Dóra

Expiscornovus
Super User
Super User

Hi @bakaidora,

 

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'))

 

twocategories.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Hi @Expiscornovus,

 

Where did you find this info?

Is there a source somewhere with the possible syntax for the odata filter on calendar?

 

Kind Regards

Tom

Expiscornovus
Super User
Super User

Hi @TomCKell,

 

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.



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,106)