Answered

Map collection data to a SharePoint List field

(0) Share

Report

Posted on by Jsharkey

I am designing a custom form that is used to new entries of a SharePoint list. One of the fields of the list called "Visitors" is designated to store information about 1 or more people.

2020-06-16 15_18_30-Change Column.png

Similar to this example: I am using a collection and a form to collect information about the visitors. My goal is to store the collection data into the Visitors column. How can I read and write the collection data to this list column? This collection needs to be connected to the field from the "New Item" form. It also needs to be readable/editable (able to be parsed back into a collection) from any view/edit forms. Can someone please advise me on how I should implement this field?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

JayMagness 1,663 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I recommend you use PowerApps to accomplish all of this.

If you want you can contact me jay@research-nest.com and we can talk about options to help you

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Jsharkey ,

Could you please share a bit more about the Collection data you used store the visitors info?

How do you submit your data back to your SP List? Using SubmitForm function?

I assume that you use SubmitForm function to submit your form data (SharePointForm1) back to your SP List, I have made a test on my side, please consider take a try with the following workaround:

On your side, please go to your Edit form (SharePointForm1), set the Default property of the Visitors Text Input Box to following:

If( SharePointForm1.Mode = FormMode.New, Concat(VisitorCollection, Name & Char(13)), // VisitorCollection represents your Collection table PlainText(ThisItem.Visitors) )

Note: The VisitorCollection represents your Collection table, the Name represents the column in your collection which stores the Visitor name. Please replace it with actual collection name and column name within your app.

Set the Mode property of the Visitors Text Input Box to following:

TextMode.MultiLine

When your Edit form is in New Mode, the Visitors field Text Box would be populated with concatenated visitor name from your collection table automatically.

Best regards,

Was this reply helpful? Yes No