cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Flow "Get items" returns blank output

Hi Everyone, hope you all are having a good day.

 

I seems to be having issues with one of my flows returning a blank ouput for the "Get Items" step.  As you can see below the "Get Items" gets the right input but it returns a blank output. This only happens for certains items, not all of them which makes it more difficult to pin point the issue. Any help will be greatly appreciated.

missing outputmissing output

 

right outputright output

 

 

6 REPLIES 6
Super User III
Super User III

Hi @DemoMan ,

 

Make sure your filter query value is correct. Is any related record exists which matches the filter query?

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered 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.

 

Thanks



Did I answer your question? Mark my post as a solution!

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


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Community Support
Community Support

Hi @DemoMan,

 

Could you please show a complete example? (block key information)

 

Or you can have a try by using the Filter array action:Annotation 2019-08-15 141437.png

Please have a try, I hope it can help you.

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I tried hardcodding the "TSLink" and I still get a blank output, it shouldn't happen this way with a hard coded number right? Is there an specific way of bulding a filer query?

Hi @DemoMan,

 

Could you please share the output of the item which TSLink is "2019-08-09_272"?

If the output of Get Items has no value of 2019-08-09_272, the issue may be caused by the SharePoint- some data about 2019-08-09_272 missed.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I have a similar issue where I have 2 sharepoint sites (one for reference of assignee variables such as dept, status, email, etc and one that is a list for action items. I have a variable that takes this data, eliminates any duplicates and also is my bypass of any null issues further into the flow. 

 

Compose - join(union(variables('AssigneeEmails'),variables('AssigneeEmails')),'; ')
 
I then have a Get Items step for the reference list with a Filter Query below:
 
Email_x0020_Address eq '@{outputs('DistinctDeptAssigneeEmails')}'
 
This should allow me to use this Get Items data for an assigning function later in the Flow, but the Get Items filter returns output { "value" : [ ] } any instance where there is more than one object in the composed output it is filtering with. 
 
I have tried several things including converting the variable back to an array after it is cleansed of duplicates, then used for the Get Item filter, but I get the same issue.
 
Any ideas on what to try next? This is a hot item for me as I was supposed to have a result by tomorrow...
 
Best regards,
Alex Cave
New Member

I'm seeing the same issue persist.   I have a simple list, containing a person lookup field, a text field that returns that individuals set approval limit.   On lookup,  I am able to get a match on the person field, but it returns a blank value in the "value" returned.

 

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (3,322)