Using Collect with multiple forms to go into a single record in Sharepoint List

[simonbarrington]

I have a Sharepoint List that forms the basis of my App. The List has around 50 columns.

The App allows people to go through various checks before they open a venue.  It has several edit forms with fields created from this list spread over several screens.

It's basically 50 questions... and go can never answer the same question twice so there is only a single entry for each column.

What I want to do is have a button on each screen that says 'Next'. This adds the results from the form on that screen to a collection called DailyCheck (so the app can work offline).

I can do this easily enough using the following code in the OnSelect of the Next button

Problem is, with each new screen and each new form it creates a new record / row in the collection so I end up with multiple records in my collection. The first edit form asks for the venue, and the second edit form (Button OnSelect code shown above) asks for the name, job title, date & headliner

What I need is for them all to be merged into a single record so at the end of filling in all the forms I can "Submit" the collection to a single record on my sharepoint list and easily process further.

Any suggestions would be gratefully received.

[v-xiaochen-msft · Accepted solution]

Hi @simonbarrington ,

I made a sample for you.

1\ Create an empty collection with all columns you need.

ClearCollect(Col,{Col1:"Test1",Col2:"Test1",Col3:1});Clear(Col);Collect(Col,{Col1:TextInput1.Text})

2\ Create second button in second screen

3\ Third screen

Result:

Best Regards,

Wearsky

[simonbarrington]

Hey Wearsky

This is great. A lot of inputting to do, but it works and has solved a lot of issues I have coming up in the future.

Bests

Simon