Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Help: Outlook Calendar...
Power Automate - Building Flows
Answered

Help: Outlook Calendar Events Filtered into Excel Sheet

(0) ShareShare
ReportReport
Posted on by CM_Flatiron 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

  • CM_Flatiron Profile Picture
    CM_Flatiron 7 on at
    Re: Help: Outlook Calendar Events Filtered into Excel Sheet

    Thanks a bunch.

     

    Cheers

  • Verified answer
    Redders Profile Picture
    Redders 546 on at
    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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans