Iโm needing to send out assignments to a handful of users on a weekly basis but they wonโt always necessarily have any assignments. In those cases, I donโt want them to receive an email. I have separate slices set up for the users for use with embedded email templates. It would appear you canโt use ISNOTBLANK on a slice (which makes sense I suppose) as it will always evaluate as empty. So what I need to do instead is check the value of the email column on the main table and see if any of the values match the email address of the user Iโm trying to send. I canโt seem to figure out a valid condition to do this. Any help would be greatly appreciated.
Hi Brian,
This could be useful.
Let me know if this is what you want.
Thanks for the reply Cesar. Iโm already utilizing USEREMAIL() in a few places, however it wonโt help me in this instance. This is solely for sending email notifications, so what I need to do is:
LOOKUP/SELECT definitely seems like the right direction, I canโt figure out how to combine that with a Yes/No condition, however.
Try this, adapt to your needs:
IF( ANY( SELECT( Table_Name[EMAIL_column] , [EMAIL_column] = [_ThisRow].[EMAIL_column] ) )=[_ThisRow].[EMAIL_column] ;TRUE;FALSE )
I donโt know how I missed this Steve, but it is excellent. Thank you!
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |