cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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.

Anonymous
Not applicable

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

 

 

 

 

Anonymous
Not applicable

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

Hi @Anonymous , 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 🙂 

Anonymous
Not applicable

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 @Anonymous , 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,";")}

Anonymous
Not applicable

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 Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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