How to include all users in a notification workflow

Iโ€™m trying to make a workflow that notifies all users when someone inserts a new entry.
I have a table that includes all users (name, email, etc.), so instead of writing the email addresses one by one, I want to make an expression for that.
SELECT(Users[Email], TRUE) - doesnโ€™t do the job.

Any idea?

0 8 335
8 REPLIES 8

If you use this SELECT(โ€ฆ) formula as a formula, not as a text, it should work. Users[Email] should work as well.

Mmmโ€ฆ it doesnโ€™t work.
I have 5 users (5 rows in โ€œUsersโ€ table).
It sends the notification just to meโ€ฆ

It sounds that you havenโ€™t deployed the app yet. In prototype mode it sends all emails to app creator.

It is deployed.

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

Itโ€™s Private, but you can check โ€œSimplex Flightsโ€

Sorry, I couldnโ€™t find any app with that name. If itโ€™s private, you can send your account ID and app name directly to aleksi@appsheet.com

Turns out that Users[Email] is not working.
With the SELECT() function, it did notโ€ฆ strangeโ€ฆ

Top Labels in this Space