Answered

Sending email notification when a cell in the "Missing Days" column is 30 on excel

(0) Share

Report

Posted on by Koyzuh

Hi,
I'm using Power Automate for the first time, because I want to receive an email notification when a customer reaches 30 days in the "Missing days" column.

I've been trying over a month but I can't figure out what the problem is!
Here is my flow and the error when I take the test.

Can anyone help me please? Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Koyzuh ,

According to your screenshot , there is no error code in it.

I test it in my side , you check if the "Missing days" in "List rows present in a table" result is a String type.

This is the data and the return in my side :

If this , you need to change the 30 to this in your condition:

In this way, we can correctly determine the result we want and execute the corresponding action.

And your screenshot is not an error, because Condition is false, so your action to send an email is Skip state.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Koyzuh 7 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much.
I don't know where I can see the code page but I changed the value "30" to "string ('30')" and when I tested it it worked the first time!
I knew it had to be something simple but I didn't know what 😅
I'm really grateful for your help. It's going to be very useful to me.

I just have a small issue that I don't know if it can be resolved.
When I receive the notification email, the name appears Andr? Jorge instead of André Jorge. Is there any way to resolve this?
Once again, thank you very much for your help.

Was this reply helpful? Yes No
Koyzuh 7 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much.
I don't know where I can see the code page but I changed the value "30" to "string ('30')" and when I tested it it worked the first time!
I knew it had to be something simple but I didn't know what 😅
I'm really grateful for your help. It's going to be very useful to me.

I just have a small issue that I don't know if it can be resolved.
When I receive the notification email, the name appears Andr? Jorge instead of André Jorge. Is there any way to resolve this?
Once again, thank you very much for your help.

Was this reply helpful? Yes No