Get calendar view of events (V3) - Filter Query

[bakaidora]

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

[Expiscornovus · Accepted solution]

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

[bakaidora]

Dear @Expiscornovus 

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

Have a nice day.

Dóra

[bakaidora]

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]

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

[TomCKell]

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]

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.