web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Combo Box selected Ite...
Power Apps
Unanswered

Combo Box selected Items to display in a another screen (form) and then save to SharePoint so an Email can be sent to them all

(0) ShareShare
ReportReport
Posted on by 1,176

Hi,

The scenario is.

 

A list of employees obtained using the Office 365 Group connection in a Combo box.

 

1st process

I need these displaying in another form with their Name, Email address, department.  

2nd Process

Once form is completed for a group discussion the Form is then saved and data saved to the SharePoint Site. Have SP column set to multi lines of text.

 

3rd Process

When record created send an Email, via flow, to all the names listed within the group for them to approve they have had the discussion

Any assistance gratefully appreciated

 

Regards

 

Chris

Categories:
  • BrianS Profile Picture
    2,407 Super User 2024 Season 1 on at

    I don't think I can provide actual code off the top of my head. You will need to use the Split() function on the initial data to generate a Table of data - I would pick one field from the ComboBox to use, probably email address as that should be unique. Then you will want to use the Concat() function to put those email addresses in your text field in Sharepoint. I would use ";" as the separator so that you can then use that field to populate your "To:" in your Email. 

    Hope that helps get you closer to a solution.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 402 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 296 Most Valuable Professional

Last 30 days Overall leaderboard