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

Like (1) Share

Report

Posted on 9 Jul 2024 22:09:59 by simms7400

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 :

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

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

Thank you.

All responses (25)

Answers (0)

simms7400 829 on 15 Jul 2024 at 13:50:52

Like (1)

Report

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 829 on 15 Jul 2024 at 13:30:46

Like (1)

Report

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

@creativeopinion

No, my field is a choice field. Not a lookup.
creativeopinion 10,464 Super User 2025 Season 2 on 12 Jul 2024 at 14:24:54

Like (1)

Report

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.

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.

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.
simms7400 829 on 12 Jul 2024 at 08:27:59

Like (1)

Report

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

@creativeopinion sure thing, here you go!
creativeopinion 10,464 Super User 2025 Season 2 on 10 Jul 2024 at 14:13:57

Like (1)

Report

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 829 on 10 Jul 2024 at 14:12:19

Like (1)

Report

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

Like (1)

Report

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

@simms7400 Can you show the outputs from the Get Items action?
simms7400 829 on 10 Jul 2024 at 13:29:19

Like (1)

Report

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 10,464 Super User 2025 Season 2 on 10 Jul 2024 at 13:01:32

Like (0)

Report
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 829 on 10 Jul 2024 at 08:03:08

Like (1)

Report

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