web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : UA8NoKrhe1JzvIEothN+qk
Power Automate - Building Flows
Answered

Help: Outlook Calendar Events Filtered into Excel Sheet

Like (0) ShareShare
ReportReport
Posted on 12 Oct 2022 14:32:58 by 7

Hello,

 

I am currently trying to create a tool which scrubs our calendars for a set of two text strings: either (AR-O) or (AR-F)

If they contain this string anywhere in the subject, the intention is to place the logged event into an excel table. My current flow is displayed below:

Current flow structureCurrent flow structure

Unfortunately, this does not seem to be working since I am receiving an unfiltered feed of data, not just subjects that contain my text strings, as seen below:

 incorrect resultincorrect result

 

I would very much appreciate some assistance in figuring out the correct flow structure. Please keep in mind I am not a developer & would prefer if the solution could be explained in plain English rather than dev jargon. 

 

Thank you very much,

Christian

I have the same question (0)
  • CM_Flatiron Profile Picture
    7 on 13 Oct 2022 at 13:05:29
    Re: Help: Outlook Calendar Events Filtered into Excel Sheet

    Thanks a bunch.

     

    Cheers

  • Verified answer
    Redders Profile Picture
    546 on 12 Oct 2022 at 20:59:12
    Re: Help: Outlook Calendar Events Filtered into Excel Sheet

    Hi @CM_Flatiron,

     

    An easy mistake to make, I'm surprised that no one replied to you earlier.

     

    By using the dynamic content that you have used, you have essentially bypassed the filter array, you have created 2 branches that are essentially doing the same thing. If you were to use the filter array, you would have needed to use dynamic content from that filter array, rather than the ones from the Outlook event trigger.

     

    Redders_0-1665608022411.png

    I couldn't actually get it to work using the filter array (I've only used this with JSON and it seemed quite complicated to try and create a solution using it) but I found a solution that will work for you

     

    Redders_1-1665608119407.png

     

    Just remember to change the condition to an 'OR'

     

    Thanks

     

    ━━━━━━━━━━━━━━━━━━━━━━━━━

     

    If I have answered your question, please mark your post as Solved.

     

    Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search.

     

    If you liked my response, please consider giving it a thumbs up. Thank you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete