Skip to main content
Community site session details

Community site session details

Session Id : FwkmuVmo6pQcGyB3uPubkR
Power Automate - Building Flows
Unanswered

Flow: Test works, automatic trigger doesn't

Like (0) ShareShare
ReportReport
Posted on 31 Oct 2022 09:32:37 by 160

Hey,

 

i can't eyplain myself the following error:

What my flow does in short:

  1. refresh excel online file
  2. wait 1 minute 
  3. list rows in excel online table
    • Checks if it's the birthday or jubilee of an employee
  4. Message the whole company via teams that the given employee has birthday/jubilee

wshalex123_0-1667208345203.png

 

 

 

Now the interesting part:

The flow is being triggered every day at 7:30

  • successfull, with now error 

wshalex123_1-1667208457177.png

--> But the flow does not finish and send any teams message.

 

wshalex123_2-1667208655516.png

 

BUT:

When i "test the flow" afterwards, it works just fine.

 

Can anyone tell me whats wrong here?

 

Thanks 🙂 

 

 

 

 

 

 

  • schwibach Profile Picture
    Super User 2025 Season 1 on 02 Nov 2022 at 13:43:37
    Re: Flow: Test works, automatic trigger doesn't

    Sounds like a time zone issue.

    I recommend not doing the comparison on power automate, not excel. If you don't open the file, it won't update

  • wshalex123 Profile Picture
    160 on 02 Nov 2022 at 13:04:17
    Re: Flow: Test works, automatic trigger doesn't

    Hi  @schwibach,

     

    exactly! In the Excel file, it checks in one column if theres a Birthday (Name =CheckBDY). If this is the case, the formula says "1". If theres no birthday it's "0". 

    In the query filter in Power Automate it Checks if there is any "1" in the CheckBDY column:

    wshalex123_0-1667393953221.png

     

    The example of todays flow at 7:30 is pretty interesting. The Output of list rows in excel action found a "1" in CheckBDY, even though there is none. So it posted The Birthday even though there isn't any.

    wshalex123_1-1667394070988.png Output

    wshalex123_2-1667394102033.png Excel

     

    Technically, the automatic flow at 7:30 gives me the Birthday at the last day. The Birthday above was yesterday!

    Is it possible it saves the Info in a cache somewhere? I can't explain this error its super strange

     

     

     

  • schwibach Profile Picture
    Super User 2025 Season 1 on 31 Oct 2022 at 15:34:17
    Re: Flow: Test works, automatic trigger doesn't

    So, just so I get it right:

    At 7:30 in the morning, the flow does not send any messages?

    But when you trigger it manually, it works fine and sends messages ?

     

    By the way, I don't see where it checks the the birthday.

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

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