Unanswered

Collection is not pulling data into SharePoint columns

(0) Share

Report

Posted on by MicroMarc365

101

I have created a repeated table in my Power App form. The repeated table is connected to a collection that I created. The form is connected to a SharePoint list and the data collection I mentioned. I want to pull the data from the collection to my SharePoint list.

Repeated Table (data source: DefectiveCollection (collection):

OnSelect of the Add icon: Collect(DefectiveCollection,{MItem: Text(Last(DefectiveCollection).MItem + 1),RefDes:"",Quantity:"",DefectCode:Choices([@'DMR - List'].DefectCode),Comments:""})

This adds a row to the repeated table.

Is there a way that I can pull the data from the collection and have it populate to my SharePoint list?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Murillo-Mariano on at

Like (0)

Report

Okay, for send the information from one collection to sharepoint, is required the collection columns have the same internal name as the sharepoint column.

To check the internal name of a sharepoint column, you have to open the list settings > open the column details > check in the end of URL the internal name, follow an example:

After make the verification, put all columns in the collection with the same internal name of the column in sharepoint, and for submit the collection, follow this formula:

Patch(DATABASE, COLLECTION)

If the ID already exists in sharepoint, the line will be replaced. If not exists, the line will be added as new.

If it helped you, please mark this as an answer!

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
@MicroMarc365

There are three ways to add data to the datasource list.

Patch the data as it is added to each control in the OnChange property of the control.

Patch the entire row once the data has been added

Add the data to a collection and then use Collect(datasource, collection) to add new fields to the datasource or if the data is being modified use Patch() to add all the rows at one time.

If you are simply adding new rows to the datasource (not editing/modifying already existing data, simply have a button to add all the rows would have an OnSelect property of: Collect(yoursplist, DefectiveCollection).

Was this reply helpful? Yes No
MicroMarc365 101 on at

Like (0)

Report

When patching, it should be Patch(SharePointList, DefectiveCollection)?

Was this reply helpful? Yes No
Murillo-Mariano on at

Like (0)

Report

If the collection columns matches with sharepoint columns internal names, yes!

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@MicroMarc365

The best way to ensure the collection matches is to initialize it with

Collect(collection, datasource); Clear(collection)

The columns will be correct and there will not be any records in the collection.

Was this reply helpful? Yes No