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
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @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.
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.
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.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
41 | |
36 | |
36 | |
22 |
User | Count |
---|---|
40 | |
36 | |
28 | |
27 | |
27 |