Flow "Get items" returns blank output

[DemoMan]

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 output

right output

[abm]

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

[v-litu-msft]

Hi @DemoMan,

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

Or you can have a try by using the Filter array action:

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.

[DemoMan]

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?

[v-litu-msft]

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.

[Alexdcave]

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

[Shaunb417]

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.