cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GabrielGondin
Frequent Visitor

sending email with recipients using filters

Hello everyone,

I am trying to send an email to more than one recipient, for this I am using two filters, the first is for everyone who has the sector "GQ-DA", the second is for the person who created the request, but is only being sent email to the person who created the request, being ignoring the first filter.
Can you help me?

 

    Office365Outlook.SendEmailV2(
        Concat(
            Filter(
                tbUsuarioQAS,
                setor = "GQ-DA"
            ),
            email & ";"
        );
        LookUp(
            tbCadastroQAS,
            ID = DataCardValue2.Selected.Value,
            'Criado por'.Email
        ),
         ..................

 

 

 

 

GabrielGondin_0-1664798781706.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
AhmedSalih
Super User
Super User

Hello, @GabrielGondin, try this:

 

Office365Outlook.SendEmailV2(
        Concat(
            Filter(
                tbUsuarioQAS,
                setor = "GQ-DA"),
                Email & ";" 
            )
             
 );
Office365Outlook.SendEmailV2(
        LookUp(
            tbCadastroQAS,
            ID = DataCardValue2.Selected.Value,
            'Criado por'.Email
        )
)

 

 

The reason is Concat will return a string within a double-quotes and the sendEmailV2 needs all emails to be between double quotes. 

 

sendEmailV2("Email1;Email2;Email3;...", .....)

What you have in your formula:

sendEmailV2("Email1;Email2;Email3;" "Email4",.....)

Email4 is the result of the Lookup function

 

Using two sendEmailV2 can be a work around.

 

 

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


Visit my Blog: www.powerplatformplace.com


 

 

View solution in original post

4 REPLIES 4
SanshubhLubal
Resolver I
Resolver I

You can use Different Different Office365 Function for that. 
and also look at this  

https://learn.microsoft.com/en-us/connectors/office365/#send-an-email-(v2)

AhmedSalih
Super User
Super User

Hello, @GabrielGondin, try this:

 

Office365Outlook.SendEmailV2(
        Concat(
            Filter(
                tbUsuarioQAS,
                setor = "GQ-DA"),
                Email & ";" 
            )
             
 );
Office365Outlook.SendEmailV2(
        LookUp(
            tbCadastroQAS,
            ID = DataCardValue2.Selected.Value,
            'Criado por'.Email
        )
)

 

 

The reason is Concat will return a string within a double-quotes and the sendEmailV2 needs all emails to be between double quotes. 

 

sendEmailV2("Email1;Email2;Email3;...", .....)

What you have in your formula:

sendEmailV2("Email1;Email2;Email3;" "Email4",.....)

Email4 is the result of the Lookup function

 

Using two sendEmailV2 can be a work around.

 

 

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


Visit my Blog: www.powerplatformplace.com


 

 

Thank you very much for your attention, have a good week

@GabrielGondin, Happy to help 🙂 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,004)