Submit Collection data in SharePoint

[ilimeli]

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.

[v-bofeng-msft]

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]

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.

[v-bofeng-msft]

Hi @ilimeli :

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

Best Regards,

Bof

[v-bofeng-msft]

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

[ilimeli]

It is 'Multiple lines of text' data type

[v-bofeng-msft · Accepted solution]

Hi @ilimeli :

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

Concat(TheCollection,Email,Char(13))

Best Regards,

Bof

[ilimeli]

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 

[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