Canvas App Email Template - Missing Cc and Bcc. How can i have those fields have different data sources

(0) Share

Report

Posted on by dsab81 Microsoft Employee

sample email template:

Above picture is a default email canvas of powerapp. i have added Cc and Bcc fields .

My case :

Bcc is sourced from 'sharepoint list' and is a combo box , To and Cc are sourced from 'Office365' and are 'regular people picker' fields.

How do the 'send email' combined formulae should be in this case that combines emailid's Bcc, To, Cc,attachments and inserted pictures ?

1. In my case Bcc field item should be a combo box and sourced from 'sharepoint list'

How do i change property of this feild

2. I also need a To and cc fields but these are sourced from Office365.

How can i achieve that.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dsab81 ,

try this:
1. Add a combo box and set the items property as:
SPListName.PeoplePickerFiledName
ex: SampleList.Personemail
2. Add a label to get the email of the required user and set the text property as:
First(Microsoft365Users.SearchUser({searchTerm:TextInput1.Text})).Mail // This needs Microsoft365Users connection
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
dsab81 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KrishnaV
I am looking for a 'send email' formulae, that combines the selected choices in To, Bcc, Cc , Attachments & Inserted Pictures to send email.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @dsab81 :
Could you tell me what Bcc field's data type is?
Could you tell me does these combo boxes allow multiple selections?
I assume Bcc field's data type is text and these combo boxes allow multiple selections.I'v made a test for your reference:
1\My data source:(List3)
2\Add three combo boxes(To/CC/BCC)
To:

Office365Users.SearchUserV2().value

DisplayFields

["DisplayName"]

SelectMultiple

true

CC:

Office365Users.SearchUserV2().value

DisplayFields

["DisplayName"]

SelectMultiple

true

BCC:
Items

List3.Bcc

SelectMultiple

true

3\Add two textinput controls(Subject/Message)
4\Add a button and set it's OnSelect proeprty to :

Office365Outlook.SendEmailV2( Concat( To.SelectedItems, Mail, ";" ), Subject.Text, Message.Text, { Cc: Concat( CC.SelectedItems, Mail, ";" ), Bcc: Concat( BCC.SelectedItems, Bcc, ";" ) } )

Best Regards,
Bof

Was this reply helpful? Yes No
dsab81 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Unable to understand what is List3.Bcc . Isnt the items value should be Office365Users.SearchUser({searchTerm:'ComboBox-Bcc'.SearchText}) ?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dsab81 :
I used my own data source to test it here (I attached a screenshot of the data source in my reply).
If you want to get user list from Officers365Users connector,Please try this:
1\BCC
Items

Office365Users.SearchUser()

IsSearchable

true

2\The submit button
OnSelect

Office365Outlook.SendEmailV2( Concat( To.SelectedItems, Mail, ";" ), Subject.Text, Message.Text, { Cc: Concat( CC.SelectedItems, Mail, ";" ), Bcc: Concat( BCC.SelectedItems, Mail, ";" ) } )

Best Regards,
Bof

Was this reply helpful? Yes No
dsab81 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft I am able to re-use your first solution and worked . But problem i see is, that i am unable to send email only to cc or only to bcc.
Unless i include some email recipient in To: , it is not sending email to recipient's in cc or bcc.

I should be able to send emails with cc only or bcc only as well , where there is no recipient in To: ?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @dsab81 :
Do you want to fill 'CC' Or 'BCC' without filling 'To'?
I'm afraid it is not available,because "To" is a Required parameter .
I think this link will help you a lot:
Send an email (V2)
Best Regards,
Bof

Was this reply helpful? Yes No