Adding a Collection to a SharePoint List

[Anonymous]

Hi all, 

I am currently working on an app that needs to add multiple lines from a collection into a specific SharePoint list.

The user needs to add data into the lower form, click the Add button which then collects the data into a collection called CleaningInfo which is then displayed in the above table. The user is able to add multiple lines to the table/Collection. Once the user has added what they need to, they then click the Submit button which inserts the lines of the collection into a SharePoint list called 'Floor Cleaning Form Records'. 

The issue I'm having is that when the Submit button is clicked, I'm getting an error:

I've have tried looking it up and fiddling with the formula bar but cannot seem to figure out where I'm going wrong. Any help would be greatly appreciated. 

(Formula for submit button for context)

[LuizVicente]

ShrePoint's Title column is required to contain data. Either you provide the data for the Title column or you remove the requirement.

To remove it, go into your list settings, select the Title column and uncheck this option:

[BlessedCobba · Accepted solution]

Hi @Anonymous 

on your sumbit button you are referencing the text fields in the form for the information in each column and not the information within the collection. 

There is a simple way to do this if your collection has the exact same Column names as your SharePoint list you can simply go 

Collect('Floor Cleaning Form Records', CleaningInfo) 

If the column names are different (or sometimes that can be a bit funky) then it needs to be something like 

ForAll(Cleainginfo
Patch('Floor Cleaning Form Records', Defaults('Floor Cleaning Form Records'),
{
SharePointColumn: CollectionColumn,
SharePointColumn: CollectionColumn,

Etc

[Anonymous]

Hi, 

I've tried the above solution but am now getting the following error:

Any suggestions?

[BlessedCobba · Accepted solution]

Hi @Anonymous 

When you are collecting the "Cleaning Method' dropdown it is saving it to the collection as a 'Record' and not a 'Text'. you will need to update how you are saving that piece of information to Cleaning Method.Selected.Text

[Anonymous]

You're a Wizard!! Thank you so much!