New Bug Encountered:issue with email report : not sent anymore

[dev2]

Hi all

I am currently in the process of building an email report : it has been working for a while, and suddenly not working anymore.
When it stopped working, I was building the email body (I am pretty sure I did not change any of other settings).

Here are the settings :

Table Name : Employes
Create report : For each row in table
Bypass Security filters : OFF
Condition :
OR( IN([Barcode Employe],ListingMvtsJour[UtilisateurResponsableActuel]),
IN([Barcode Employe],ListingMvtsJour[UtilisateurResponsableInitial]))

and in the “DO THIS” section :
To : [Mail]

This column [Mail] is part of the table “Employe”, and is a column containing exclusively email adresses or blank cells.
“ListingMvtsJour”’ is a slice, and the “View Data” displays only one row, which is what I expect at the moment.

The Workflow report says the email was sent (green binocular), to one user : which is what I expect, one email should be sent to me.
Here is the report :

Many thanks for your help !

Aurelien

[Aleksi]

Have you checked that your email box is not full or is it possible that your inbox is rejecting noreply@appsheet.com?

[dev2]

Hi @Aleksi

Thanks for your answer.

1. The email Box should not be full, I only have 350 mails in the inbox (this is a new mailbox)
2. About rejecting, :

• I have been looking at the spam : nothing
• Mail settings : nothing seems to be blocked

[dev2]

I am currently trying a very simple setting for sending email :
Table name : EMployes
create report : for entire table

condition : nothing
to : dev@lfsols.ch (my address)
email body : “TEST” (without quote)

The log displays successfull operation, but nothing comes into my mailbox

[Aleksi]

How big is your table? How many rows?

[dev2]

“Employes” has 7 columns and 43 rows.
But the sheets goes till 1000 rows

[Aleksi]

Is your app deployed?

[dev2]

yes

[Aleksi]

What happens if you press “Test” or have you tested in this way already?

[dev2]

I read about this “Test” button, but I don’t see it.
Can you tell me where to find it?

[dev2]

I just understood wich “test” you are talking about.
I’m running as much as I can

[dev2]

So,

I tested on Condition and on email address :
Everything seems to be OK ?

[Aleksi]

Sorry… I mean “Run”, not “Test”.

[dev2]

OK. So yes, this is the way I try every time since I work on it.
And when I assume I’m supposed to get an email, I don’t get anything.

[Aleksi]

What is your account ID number and app name if I check your app?

[Aleksi]

And the email address is typed correctly?

[dev2]

Yes I’m sure about my email address. I checked more than twice in case, it should be OK

OK, here are informations :
app name : Outillages_v1b-1009434
account ID number : 1021166

Thanks

[Aleksi]

Please test this… add aleksi@appsheet.com into TO field and then run it again so we can be sure that the reason is somehow not your email address.

[dev2]

I just entered your address, saved app, and ran the report.
Did you received anything ?

[Aleksi]

No, I didn’t receive.

[dev2]

I will just check the log…one minute.

Result : Success, and your address is in “EmailTo” field

[Aleksi]

Log is fine.

[Aleksi]

Let me test this with a test app…

[Aleksi]

It seems that there is something wrong with the report service. I will ask our Workflow expert for debugging.

[dev2]

OK, thanks, I will wait for news then.

Have a good day in the meantime !

[Aleksi · Accepted solution]

It should be fine now. Though it will take a short while to clear the backlog. Thanks for this info!

[dev2]

OK, I will try and let you know. If I don’t write you back within 2 days, that mean it will be fine !

Thanks again

[dev2]

Hi @Aleksi,

I’ve been trying to run again the mail, but nothing seems to happen.
At first I sent it to your email address by mistake, but then I replaced the “To” field with my address, and this is when I realized that still does not work.
So that was yesterday, 12 hours ago.
And I just tried again in case, nothing more.

Maybe you received something yesterday ? Let me know
(I’ll be busy today, I’ll probably see your answer tomorrow, same time)

Thanks

Aurelien

[Aleksi]

Yes I received an email… I received it 04:02 PM UTC+0

[dev2]

Hi @Aleksi

Good to know you received something.
I’m still meeting issues with that.

• I tried with my own personal address : amoyen31@gmail.com, it was successful too.
• I tried with dev@lfsols.ch, was a fail (even if log is successful)
• I tried to send a mail to two addresses, at typing: dev@lfsols.ch,amoyen31@gmail.com: this time, nothing comes into my personal address.
• BUT if I type “amoyen31@gmail.com,dev@lfsols.ch” (without quotes) this time I get something, in my personal address only.

I looking to the Log, it seems that:
-only the first address seems to be kept :

• address dev@lfsols.ch goes to successful operation, even if nothing goes in the inmail box

I checked again if there was any spam or blocked email or email list, but settings are empty on the dev@lfsols.ch.
And the most astonishing to me, is that it used to received every mail while I was working on the email body

Do you have any idea of why this does not provide any mail on this address ?

Thanks

Aurelien

[Aleksi]

When adding more than one email address, add them in a seprate line in your To field. For me it sounds that your inbox (dev@lfsols.ch) is either full or it’s rejecting noreply@appsheet.com.

[dev2]

Hi @Aleksi

Thank for the tip.
I think as well my mailbox is rejecting this address, because in the same G-suite domain, my first user can receive his mails, so…mine must be in trouble.
Anyway, this doesn’t matter while the “normal” users still can get their mails : this is necessary for further developments.

Many thanks for your help on this case !

Aurelien

[Aleksi]

You’re welcome