Answered

Filter Excel data and send one email based on condition

(0) Share

Report

Posted on by crp_

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.

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

crp_ 22 on at

Like (0)

Report

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).

Was this reply helpful? Yes No
Verified answer

crp_ 22 on at

Like (0)

Report

Hi all,

So this was the final result:

Everything works perfectly. I hope this helps someone in future.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (1)

Report

Hi @crp_ ,

Glad to see you solved the problem.

You could mark yourself as a solution.

Best Regards,

Wearsky

Was this reply helpful? Yes No
crp_ 22 on at

Like (1)

Report

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:

Was this reply helpful? Yes No