cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ilimeli
Microsoft
Microsoft

Submit Collection data in SharePoint

Hi all,

I am trying to figure out how to submit one particular column with multiple rows from a collection to a column in my SharePoint list. 

In the application, the users selects names and those names selected are saved in the collection and need to be stored into a sharepoint column, 'Selected Users', once the form is submitted. What should the datacard value be for that column?

 

Appreciate any help.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @ilimeli :

You could set the 'Selected Mentors Emails''s datacard's Update property to:

Concat(TheCollection,Email,Char(13))

vbofengmsft_0-1645755343284.png

Best Regards,

Bof

 

View solution in original post

8 REPLIES 8
v-bofeng-msft
Community Support
Community Support

Hi @ilimeli :

Could you please show more details?

How do you submit the record? Using SubmitForm or Patch ?

What's the meaning of "submit one particular column with multiple rows from a collection to a column in my SharePoint list" ?  Do you want to update an item's specific field with multiple values? What is this field(submit one particular column with multiple rows from a collection to a column in my SharePoint list)'s datatype?

What is the collection's data structure? Could you please provide some screenshots or demos?

Best Regards,

Bof

ilimeli
Microsoft
Microsoft

Hi @v-bofeng-msft , for sure.

 

It is an app that selects mentors. Once the users selects the mentors (up to 5), the mentor info gets saved in a collection. For example, one column is email:

 

The SharePoint List has a column called 'Selected Mentors Emails' that needs to be set equal to the email column values in the collection. This all gets submitted through SubmitForm. 

I am not sure what functions to use for 'Selected Mentors Emails Data_Card' Default. 

 

Let me know if that makes sense. Thanks.

Hi @ilimeli :

Please be careful to protect privacy information, I have removed the pictures with the email address.

Best Regards,

Bof

Hi @ilimeli :

Could you please tell me :
What is 'Selected Mentors Email' 's data type? Is it a Person or Group column or a multiple line of text column?

If 'Selected Mentors Email' is a  Person or Group column, does it allow multiple selections?

Best Regards,

Bof

It is 'Multiple lines of text' data type

Hi @ilimeli :

You could set the 'Selected Mentors Emails''s datacard's Update property to:

Concat(TheCollection,Email,Char(13))

vbofengmsft_0-1645755343284.png

Best Regards,

Bof

 

Thank you Bof, that worked perfectly.

Now my column in my SharePoint looks like this:

xxx@hotmail.com

xxxx@hotmail.com

xxxxx@hotmail.com

 

Now when I want to call each email separately, how can I separate 1 from the other 3?

For example, I need xxx@hotmail.com value and not the other 2.

 

Thank you again @v-bofeng-msft 

Hi @ilimeli :

You could split the value by Char(13) and then get the first result

First(Split(TheValue,Char(13)))

BestRegards,

Bof

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,735)