Answered

Not finding any true to my condition

(0) Share

Report

Posted on by CTASS

I need to automate sending an email to my sales members when their customers are CASH customers and they have paid less than half down on their bill. This is the spreadsheet I'm dealing with:

I have the AR/CASH column set to Text.

This is the flow I am working on first just to find which customers are Cash customers, represented by CA in the spreadsheet. I have tried it with "Contains" and with "Is equal to" and I've tried it with Expression 2 being a string like 'CA'

The tests keep "succeeding" but I never receive any emails. When I look at the results every entry says "false"

I know it must be very simple...I'm very new to this and very frustrated!! I can't get past the first step before even worrying about how to do the math to figure out who owes more money.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

GeorgiosG 1,013 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CTASS ,

can you try in the condition to wrap the AR/Cash column via expressions in a string function i.e. string(AR/CASH)

It always helps to insert the „Compose“ action before a condition and insert the values you want to compare in there. That’s how you can make sure that you compare the expected values.

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CTASS ,

It could be caused by the slash( / ) in the column name, maybe you could try the following formula instead of Dynamic content.
items('Apply_to_each')?[concat('AR','/','CASH')]
As @GeorgiosG said that, Compose Action is your good helper.

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
CTASS 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! I changed the name of the column and it worked perfectly!

Was this reply helpful? Yes No