Issue with Loop Over Items Node and IF Node

[Taher_Sedky]

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)

Thanks in advance.

[jabbson]

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?

[atwork1]

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:

[Taher_Sedky]

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.

[Taher_Sedky]

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

[jabbson]

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

[Taher_Sedky]

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.