Skip to main content
Community site session details

Community site session details

Session Id : LsL+xAywC71e7FngJlbEca
Power Automate - Building Flows
Unanswered

Flows with 'Get Items' no longer working since late June

Like (1) ShareShare
ReportReport
Posted on 9 Jul 2024 22:09:59 by 829

Hi All -

 

I have multiple flows that stopped working. I'm not sure why. 

 

I have a flow using 'Get Items' but it's not rendering any results :

 

PA1.PNG

 

Here is a screen shot of my list showing it SHOULD be consumed :

 

PA2.PNG

 

It seemed to break around June 27th. Is anyone aware of what may have happened or why this isn't working anymore?

 

Thank you.

 

  • simms7400 Profile Picture
    829 on 15 Jul 2024 at 13:50:52
    Re: Flows with 'Get Items' no longer working since late June

    @creativeopinion 

     

    Here is something interesting. I changed 'Workflow_Notified' to a free text field instead of choice, and still seeing the SAME behavior of not pulling in any records based on the Filter Query. WHAT THE HECK

  • simms7400 Profile Picture
    829 on 15 Jul 2024 at 13:30:46
    Re: Flows with 'Get Items' no longer working since late June

    @creativeopinion  

    No, my field is a choice field. Not a lookup. 

  • creativeopinion Profile Picture
    10,464 Super User 2025 Season 2 on 12 Jul 2024 at 14:24:54
    Re: Flows with 'Get Items' no longer working since late June

    @simms7400 To confirm, your column isn't a look up column? The only reason that the Filter Query wouldn't be able to filter on that column would be because it's a look up column. You can confirm this in the List Settings of your SP list. 

    creativeopinion_1-1720787298596.png

    If your column is a look up column you'll need to use a filter array action to filter out by the values of that column. 

    creativeopinion_1-1720794115302.png

    Verify the expression in the advanced mode. The Filter Array action may not wrap your text in single quotes and you might have to enter those manually. I find it impossible to edit expressions in the Advanced Mode as the cursor jumps around. Instead, I'd recommend copying/pasting into a text editor—make your changes and copy/paste back into the field. 

    creativeopinion_2-1720794157583.png

    creativeopinion_3-1720794287938.png

     

     

     

     

  • simms7400 Profile Picture
    829 on 12 Jul 2024 at 08:27:59
    Re: Flows with 'Get Items' no longer working since late June

    @creativeopinion  sure thing, here you go! 

     

    PA6.PNG

  • creativeopinion Profile Picture
    10,464 Super User 2025 Season 2 on 10 Jul 2024 at 14:13:57
    Re: Flows with 'Get Items' no longer working since late June

    @simms7400 Can you scroll down in the outputs to the dynamic content you are trying to filter on? I'd like to review the output of the Workflow_Notified column.

  • simms7400 Profile Picture
    829 on 10 Jul 2024 at 14:12:19
    Re: Flows with 'Get Items' no longer working since late June

    PA5.PNG

  • creativeopinion Profile Picture
    10,464 Super User 2025 Season 2 on 10 Jul 2024 at 14:08:15
    Re: Flows with 'Get Items' no longer working since late June

    @simms7400 Can you show the outputs from the Get Items action? 

  • simms7400 Profile Picture
    829 on 10 Jul 2024 at 13:29:19
    Re: Flows with 'Get Items' no longer working since late June

    @creativeopinion  Interesting! That worked.  I wonder why?

     

    Why wouldn't Workflow_Notified eq 'FALSE' work?

  • creativeopinion Profile Picture
    10,464 Super User 2025 Season 2 on 10 Jul 2024 at 13:01:32
    Re: Flows with 'Get Items' no longer working since late June

    @simms7400 Another test you can run in your flow is to use a filter query to return that specific item and review the outputs from the Get Items action.

    ID eq 8277

     

     

  • simms7400 Profile Picture
    829 on 10 Jul 2024 at 08:03:08
    Re: Flows with 'Get Items' no longer working since late June

    @FLMike  not sure what you mean about comparing the column itself. Can you elaborate? The way I have set the Filter Query has been working for years.  Not just in this flow, but many others. I'm not sure what you mean. 

     

    @creativeopinion  the flow return records when I remove the Filter Query. Not sure Dynamic Content is the issue, but will try it

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

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!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2