Email workflow - increasing expression efficiency for To: addresses

I’m using the following expression to build a list of email addresses to use in an email workflow. In my use case, the user fills out a simple form, an ENUMLIST column is used to select which TEAM to include on the email sent by AppSheet. This works, but it seems inefficient (judging based on increased Sync time). Can anyone com up with a more efficient expression? Are there any other ways to speed up email workflows that I may be overlooking? Thanks in advance!

Ifs(IN(“Admin”, [TEAM]), select(OAR STAFF[EMAIL], [Admin]=“Green”)) +
Ifs(IN(“CageWash”, [TEAM]), select(OAR STAFF[EMAIL], [CageWash]=“Green”)) +
Ifs(IN(“Management”, [TEAM]), select(OAR STAFF[EMAIL], [Management]=“Green”)) +
Ifs(IN(“team 1”, [TEAM]), select(OAR STAFF[EMAIL], [team 1]=“Green”)) +
Ifs(IN(“team 2”, [TEAM]), select(OAR STAFF[EMAIL], [team 2]=“Green”)) +
Ifs(IN(“team 3”, [TEAM]), select(OAR STAFF[EMAIL], [team 3]=“Green”)) +
Ifs(IN(“VetServices”, [TEAM]), select(OAR STAFF[EMAIL], [VetServices]=“Green”))

Solved Solved
0 3 551
1 ACCEPTED SOLUTION

I received excellent help from @Phil and @Steve in my other, related post - thank you both!

Check it out here: SMS workflow - is it possible to initiate a group text from AppSheet

View solution in original post

3 REPLIES 3

My response to your other post describes a solution that will help a lot.

See SMS workflow - is it possible to initiate a group text from AppSheet

@Phil I see, if I model the email data in the same way as phone number data (per your other suggestion) I may expect faster processing time. Again, I’ll update this conversation once I’ve tested.

for any others looking in, my other question can be found here: SMS workflow - is it possible to initiate a group text from AppSheet

I received excellent help from @Phil and @Steve in my other, related post - thank you both!

Check it out here: SMS workflow - is it possible to initiate a group text from AppSheet

Top Labels in this Space