cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dmc_103
Helper III
Helper III

How to collect information without using Collections?

Hi Power Apps Community,

Currently in the process of creating a request app with the ability to Cc multiple email addresses when a Send Button is clicked. For this, I am using 365 as data source and gallery.

However although I can select multiple emails, it only sends to 1 email (usually only the one at the top of the list) when the Send Button is clicked. 

Is there a way to collect the selected multiple email addressed without using collections? Thank you! 

16 REPLIES 16
Alex_Security
Resolver I
Resolver I

Hi DMC,

 

depending how you're selecting the users (assuming its a gallery in this case) you are able to Concat YourGallery.AllItems with the semicolon seperator and then set that Concat as the input for your CC, essentially separating in the same way outlook would.

 

let me know if that solves your problem, and if it does feel free to mark it as a solution!

 

Thanks,

 

Alex.

Hi @Alex_Security 

In the gallery, an icon  is used to select a specific email address. I would like to your idea. Can you walk me through it? Where should I add the Concat function, in the gallery's display mode or default?

Alex_Security
Resolver I
Resolver I

Hi Dmc,

 

of course.

 

so in your gallery, set a collect item for the icon onselect function, as per the below:

 

Collect(EmailAddresses,ThisItem.Email) - if using the office365users connector then use .mail as opposed to .email, i just built a table for this example 🙂

 

then you can use either the function itself - Concat(EmailAddresses,Value,";") in your CC option for email, or add it into a text label and reference the label in your send email function. example below:

 

Alex_Security_0-1616757951163.png

 

 

 

 

dmc_103
Helper III
Helper III

Thank you @Alex_Security , quick query: Is the "EmailAddresses" in your example the name of the table you created?

Hi @dmc_103 , its the name of the Collection created by the icon, you can name it to whatever you like, just ensure its the same collection in the Concat function 🙂 

dmc_103
Helper III
Helper III

Hi @Alex_Security  my icon has this string so I can see both Name and email address when collected:

dmc_103_0-1616760910521.png

NOTIFIED is the name of the Collection.

 

In my send button - Cc looks like this: 

dmc_103_1-1616761086524.png

I also tried: 

dmc_103_2-1616761253492.png

 

Both don't seem to work or did I miss anything?

 

 

Alex_Security
Resolver I
Resolver I

Hi @dmc_103 , In your Collect you'll need to put Collect(NOTIFIED, ThisItem.Mail), as it'll need the email specifically to know what to Concat 🙂 

or failing that, if you want to keep both the name and email in the collection, edit your CC to this:

 

{cc: Concat(NOTIFIED.Email,";")}

dmc_103
Helper III
Helper III

Hi @Alex_Security 

Yes, I want to keep both. So I made changed in my Cc:

dmc_103_0-1616763732831.png

Also tried this: 

dmc_103_1-1616763966533.png

No squiggly lines but it did not attach any email when I click Send 🙂 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,761)