Unanswered

Get calendar view of events (V3) - Filter Query

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

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

Was this reply helpful? Yes No
bakaidora 6 on at

Like (1)

Report

Dear @Expiscornovus
thanks for your help, this is the perfect solution for my issue. 🙂
Have a nice day.
Dóra

Was this reply helpful? Yes No
bakaidora 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

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

Was this reply helpful? Yes No
TomCKell 13 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No