Hi there, new to Power Automate and I've been stuck on this for days. Seems really quite basic.
All I'm trying to do is filter a few rows of data based on a condition (price > $500.00 - so should return AMZN) and send an email. The data is below:
This is the flow:
This is what is fed into the array:
This is the output:
Not entirely sure what's going on here, but any help is greatly appreciated.
Solved! Go to Solution.
Just commenting so far because I've managed to overcome the filtering issue by changing price to a float type with the following: float(item()?['price']) and then also doing the same with the value (wrapping it in a float type) - so in this instance float(500).
Also, just to note here - for the email part, take the email outside of the 'apply to each' loop. This prevents the email sending multiple times (because otherwise you're iterating through the rows). You only want to do this once, so use an initialise variable and loop through the data then use an append to variable. Then attach variable to the email.
Should look like this: