cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DemoMan
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
abm
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 blogPower Automate Video Tutorials
v-litu-msft
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
Shaunb417
Frequent Visitor

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,911)