Hi,
Newbie here.
I'm trying to send a report every time a new record is added to a table, but the report is sent before related data in another table is added, thus the report ends up incomplete.
Mi first table is 'Certificates' (think of inspections), and the second 'Items'. 'Certificates' is referenced by 'Items', and 'Items' "is a part of" 'Certificates'. So when you add a Certificate you must create new Items.
When the 'Certificate' is done and added, a report of which items contains should be sent via email. But I believe that the Certificate is added to the Certificates table, the email is sent, then the items are added to the items table. Resulting in a empty report.
If I test the automation with a previously made Certificate, the sent report is fine. No trouble with formating the report whatsoever.
Now, I can make the automation wait 5 minutes before sending the report (what I'm doing now). But is a kind of cheap solution.
Also tried "Wait until condition" where the condition was "=IN([_THISROW].[ID], ITEMS[ID])" or "=IN([ID], ITEMS[ID])". But yielded no email, even.
How could I make the automation wait for the Items referencing the certificate be added before sending the mail?. Is my approach even correct? I imagine a invoice app should work similarly.
Hope I explained myself.
ยกGracias!
LinkedIn
Twitter
