I want to take the first name, last name, and email address from an Excel table1, and when a new row receives a new entry, that is the trigger. Then an email should be sent to the email address specified in Excel with the text: Hello first name last name, here is the information.
Unfortunately, I get an error message saying “Validation failed for 1 parameter(s)” that I cannot understand at all. Maybe someone can help me or create this correctly?
Thanks in advance.
Hey @Sven_Kunze Welcome to the community!
Can you please share relevant scenario screenshots and errored module?
Best,
@Prem_Patel
I inserted a module called “watch table rows,” linked a table, and attached the Outlook module, where I used the email from the Excel table to send it. This works so far, but an error occurs when I trigger the process without adding a new row to the Excel table. The module then cannot find an email address and displays the following message: “Invalid email address in parameter ‘address.’” I wanted to solve this using a filter that says Row Email with the basic operator Exists, but that doesn’t work. How can I solve this so that the filter only continues to the Outlook module if a new email address has been added to the list?
The filter is not the problem, but rather the table row ID. This continues to count independently of what the filter does. This means that when I trigger the loop and there is no new entry, no email is sent, but the count is incremented by one, and the row is omitted during the next run. How can I prevent this? I simply want to check whether there are any new rows and, if they contain an email, send an email.
Welcome to the Make community!
We’d love to help, however, you have not provided sufficient information to demonstrate the problem that would allow us to reproduce the scenario and any issue/s and/or error/s.
To allow others to assist you with your scenario, please provide the following:
We need to see what you’re working with to give you the best advice. Screenshots are extremely important because Make is a visual editor — a picture provides us with more context.
It would help us identify the issue by having screenshots of:
Please export the scenario blueprint. Providing your scenario blueprint file will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return - this would greatly benefit you in implementing our suggestions as you can simply paste module exports back into your scenario editor!
To export your scenario blueprint, click the three dots at the bottom of the editor then choose ‘Export Blueprint’.
Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).
Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.
Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.
You can upload the file here by clicking on this button:
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
To provide code/text using Markdown format, you can type a code fence.
Add three backticks ``` in a separate line before and after the content, like this,
```
text goes here
```
Alternatively, you can upload your file and share the public link** —
(this method is only recommended for large files exceeding the forum upload limit)
Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved, and help you with mapping the raw property names from collections.
Sharing these details will make it easier for others to assist you.