How to fix the flow that displays 'Null' as an output

[lo_ori]

I am trying to auto-populate an excel template using another excel template. Everything is working fine but the thing is my Select Actions returns Null values whenever I test the flow. Here's my overall flow:

The 'apply to each' action is linked to the list rows present MD Name. and the select action is linked to the Filter Array action. Here's the error that keeps on popping out whenever i try to test the whole flow:

[creativeopinion]

@lo_ori Can you share a screenshot of your flow in the Classic Designer (toggle off the New Designer). It's still a bit buggy. If you can expand all actions in edit mode and upload a screenshot of your full flow—it'll help to provide more insight on your flow logic. 

In the meantime, you might find this YT Tutorial helpful: Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

1️⃣ Cross-Referencing Data

2️⃣ Filtering by Key

3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:

✅ 3 Ways to Use the Filter Array Action

✅ How to use the Scope Action to Group Actions

✅ How to Check the Number of Items returned from a Filter Array Action

✅ How to Cross-Reference Data in Excel with a SharePoint List

✅ How the Filter Array Action Works

✅ How to Access the Dynamic Content from a Filter Array Action

✅ How to Filter Items by a Key

✅ How to Filter Items by Matching a Substring

✅ How to Use Multiple Conditions in a Filter Array Action

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

[lo_ori]

Hi @creativeopinion ! Thank you so much for replying. here's my whole flow as requested:

 Appreciate your help on this. thank you!

[creativeopinion]

@lo_ori Can you confirm that the output of this Compose action has outputted a number? I'm assuming you are using the length() function to return a count of items from the Filter Array action. 

Also, can you hover over one of these dynamic content labels and screenshot the expression that displays? 

[lo_ori]

Hi @creativeopinion ! Yes, it returns the number that the MD Name showed in the main data. 

Also, here's the select action. This specific action is linked to the filter action above but the content came from tableMain Data. I typed each expression since if i linked it directly it will be nested under a 'for each' action.

 

[lo_ori]

Hi @creativeopinion ! I somehow managed to put an expression that can pull the data. Problem is the output keeps on repeating. I have no problem with the input as it filtered all the correct info. Can you help me identify how can I fix my expression here:

Sample output: 

Here's the expression I made: (Select Action is based on the filter action I made)

[creativeopinion]

@lo_ori The expression is incorrect. the first part of your expression should be:

 item()?['DynamicContentKey']

The dynamic content key is the text in black between the double quotes. Insert the dynamic content key text between the single quote marks. 

To avoid any errors in your flow. I would recommend inserting a condition action before the Select 2 action to check if the Filter Array action returns any items. If the output of the Compose action is not equal to 0 insert the subsequent actions into the YES branch.

[lo_ori]

Hi! @creativeopinion , i tried the expression that you have but i can't  save the whole flow. Can you also please elaborate the condition action you mentioned? Apologies, i'm still new in power automate and still trying to figure things out.

[creativeopinion · Accepted solution]

@lo_ori Can you please share a screenshot of the Select action and the expressions you've used. Refer to this section of the YT Tutorial I've linked below to see what I mean about adding a Condition action. 

5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram