Issue with Loop Over Items Node and IF Node

Questions
1

I am trying to create a flow in n8n that extracts data from raw materials excel sheet on Onedrive, the flow should send a Teams message with a shortlist of the raw materials which their current stock is less than the safety stock.

The flow executes but the results are wrong. (Please see images for more clarification)

IMG_7847
IMG_78471345Ă—529 36.9 KB

IMG_7848
IMG_78481130Ă—488 35.1 KB

Thanks in advance.

2

Hey @Taher_Sedky hope all is well. Welcome to the community.

You probably want to mention what is wrong with these results. Or would you like us to guess? :slight_smile:

1 Like
3

I dont think, that you need the loop node.
the If node filters the valid entries, and instead of a merge you can use a aggregate node to create a list of the valid items to pass on to a teams message

edit:

2 Likes
4

Thanks @jabbson for time, the issue is that I should get three results fulfilling the condition of the “IF” node but I only get two results out of the true branch.

5

Thanks @atwork1, I’ll give it a try and get back to you.

6

You probably want to connect the false to the input of the Loop Over Items. Try that.

7

Thanks a lot Christian, I took your solution and did it as shown, it worked.

The next step is to connect the “Aggregate” node to “Send Chat Message” node of the MS Teams, which I might ask about if you don’t mind.