Hello Experts,
I have one detail view in the app. Below is the view:
Now, I would like to send email to all the people through Action. The email id is available in different worksheet.
So Names are available in a worksheet and their email ids available in different worksheet.
How I can get all the peopleโs email id from different worksheet in this view and send email to all of them?
Is it possible to fetch all the email id from different worksheet based on name value?
Thanks,
Arindam.
In generally you can read the email with the LOOKUP formula like LOOKUP([_THISROW],[Management],Names,Name,Email)&","&LOOKUP([_THISROW],[Support],Names,Name,Email)&","&LOOKUP([_THISROW],[Purchasing Operations Replacement],Names,Name,Email)
Hello Aleksi,
Thank you for your suggestion. I did exactly same thing and add virtual column for this.
You are absolutely genius .
Thanks,
Arindam.
You would not need to add a virtual column. If you trigger the Workflow Email with the action button, you could add that formula directly into โToโ field.
Hello Aleksi,
Thanks for your suggestion. But if I consider workflow email, then I have to provide one Event like โAdd Onlyโ, โUpdate Onlyโ Like that. But I dont want this event.
Any suggestion on this.
Thanks,
Arindam.
More sofisticate version could beโฆ
SELECT(Names[Email],IN([NAME],LIST([Management],[Support],[Purchasing Operations Replacement])))
Thank you Aleksi for your responseโฆI did it with your suggestion.
Thanks,
Arindam.
Youโre welcome
User | Count |
---|---|
36 | |
33 | |
28 | |
23 | |
18 |