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 / patch a whole collecti...
Power Apps
Answered

patch a whole collection column to one row in SharePoint

(0) ShareShare
ReportReport
Posted on by

Hello ,

 

I was wondering if anybody can help me with this.

 

I have a combo box that I have linked to our 365 users, so we are able to select multiple users. Then once the people are selected I save their emails into a collection. What I want to do is, on my submit button to  have all those emails that I have saved to my collection to go to my SharePoint list under the Column EmaillCC1, but all in on row and in one field so an example, if my collection has 3 emails, bsmith@example.com  , tray@exacmple.com and smark@example.com. I want my SharePoint list  so show under the column EmaillCC1 all those 3 together separated by a comma. Is that possible ? 

this is what I have done so far for the combo box 

Thanasis_0-1651683133730.png

 

And this is my submit Button

 

Patch(
 NewHireInfo,
 Defaults(NewHireInfo),
 {
 FirstName: FirstName2.Text,
 LastName: LastName2.Text,
 StartDate: StartDate2.SelectedDate,
 PhoneNumber: PhoneNumber2.Text,
 PersonalEmail: PersonalEmail2.Text,
 Branch: Branch2.Selected.Result,
 Address: Address2.Text,
 Address2: SecondAddress2.Text,
 TrainingDate: TrainingDate2.SelectedDate,
 Delivery: Deliverymethod2.Selected.Value,
 Manager: Manager2.Selected.Result,
 EquipmentNotes: Notes2.Text,
 JobType:JobType2.Selected.Value,
 JobTitle:JobTitle.Selected.Result,
 NewJobTitle:NewTitle.Text,
 BranchCode:BranchCode2.Selected.Result,
 NewBranchAddress:NewBranchAddress2.Text,
 EmailCC1:NHCC1.Selected.Result
 
 

 }
);

Reset(NHCC1);



Navigate(NewHIreScreen6);

 

 

Any Help I would really appreciate it. 

 

 

Categories:
I have the same question (0)
  • Verified answer
    Thanasis Profile Picture
    on at

    So I was able to fix the issue with creating a text field and then concat the collection there. 

    Concat(emailfor2, Mail, ", ")

    so now my filed has all the email accounts separated by a comma. 

    Then on the submit button, I just write that text field in a column, clear the collection and then reset the combo box.  

     

    I will just put it here just in case anybody else is having the same issue I had. 

  • v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi @Thanasis ,

     

    Congratulations!

     

    Glad to see you solved the problem.
    You could mark your answer as a 'solution' so that it will be useful for others and close the case.

     

    Best Regards,
    Charlie Choi

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 477

#2
WarrenBelz Profile Picture

WarrenBelz 341 Most Valuable Professional

#3
11manish Profile Picture

11manish 317

Last 30 days Overall leaderboard