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
Solved! Go to Solution.
It should be fine now. Though it will take a short while to clear the backlog. Thanks for this info!
Have you checked that your email box is not full or is it possible that your inbox is rejecting noreply@appsheet.com?
Hi @Aleksi
Thanks for your answer.
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
How big is your table? How many rows?
“Employes” has 7 columns and 43 rows.
But the sheets goes till 1000 rows
Is your app deployed?
yes
What happens if you press “Test” or have you tested in this way already?
I read about this “Test” button, but I don’t see it.
Can you tell me where to find it?
I just understood wich “test” you are talking about.
I’m running as much as I can
So,
I tested on Condition and on email address :
Everything seems to be OK ?
Sorry… I mean “Run”, not “Test”.
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.
What is your account ID number and app name if I check your app?
And the email address is typed correctly?
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
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.
I just entered your address, saved app, and ran the report.
Did you received anything ?
No, I didn’t receive.
I will just check the log…one minute.
Result : Success, and your address is in “EmailTo” field
Log is fine.
Let me test this with a test app…
It seems that there is something wrong with the report service. I will ask our Workflow expert for debugging.
OK, thanks, I will wait for news then.
Have a good day in the meantime !
It should be fine now. Though it will take a short while to clear the backlog. Thanks for this info!
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
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
Yes I received an email… I received it 04:02 PM UTC+0
Hi @Aleksi
Good to know you received something.
I’m still meeting issues with that.
I looking to the Log, it seems that:
-only the first address seems to be kept :
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
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.
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
You’re welcome
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |