Patch() for collection to sharepoint with over 120 columns?

(0) Share

Report

Posted on by Suni

Hello,

I am working on a solution to my problem for a few days now.

The App works based on different SharePoint-Lists. I import a list (~15-20 rows with ~120 columns each) into a Collection with ClearCollect(). The app will modify the collection in different rows and columns. The changes made can be very little (2-3 changes) or entire rows that get changed (100+ changes).

The user should be able to upload the collection back into the SharePoint by pressing a button. I know that I can use patch() for that, but I don't understand how. Is there an easy way to blindly copy the whole collection back into the SharePoint? I don't need to look for changes made. Overwriting the old list with the Collection in the app would be all I need.

If patch() is the only option, can someone give me an example?

I will add a small Table with the first few columns of my list/collection. The table starts with some object specific information. The pattern of ColumnH-J (2x Yes/No, 1x text) will repeat for ~40 times.

'ClearCollect(LocalCollection;'DN-OK')'

LocalCollection:

ColumnA	ColumnB	ColumnC	ColumnD	ColumnE	ColumnF	ColumnG	ColumnH	ColumnI	ColumnJ
text	text	text	text	date	date	text	Yes/No	Yes/No	text

I started using PowerApps 2 months ago. I learn new things every day, but patch() is something I didn't understand so far. Looking into allready asked questions gave me even more '???' in my head.

I hope to lift some blockers in my head and work towards a solution to my problem.

If you have any questions, feel free to ask!

Thank you for your time and help! 😊

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Mx81 860 on at

Like (0)

Report

It depends on....

how do you have the data in powerapps? In a form?
dann you can use this:

Patch(SharePointList,Filter(SharePointList,Id=sharepointId),YourForm.updates)

if the fields (columns) in your app has the same name as in SharePoint you can use collect(SharePointList,YourPowerAppsCollection) to patch it all at once.
ClearCollect doesn’t work here!!!

Was this reply helpful? Yes No
Suni 39 on at

Like (0)

Report

I use ClearCollect to import the SharePointList at the begining. The user can choose between different lists (all departments have seperate SharePointLists, but they are all build exactly the same).

The user will pick an item from the Collection (he can browse through the items with a gallery). The survey is done with EditForm. The app will ask questions and write the answeres into 3 columns for each question (Question 1 is CloumnJ-H). All of that is done with EditForm.
I hope this answeres the question how I have my data in powerapps.. 😁

I will only edit the Value of the fields (example ColumnName 'Is the car dirty?', value in the field for car XYZ can be YES or NO). The Question itself (Headline of the Column) will never be changed.

I was looking into collect() to write everyting back, but it seemed like it would add new rows instead of overwriting the already existing rows, or am I wrong?

Where is the difference between a form and a collection? What does 'YourForm.updates' do?

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (1)

Report
Hi @Suni ,

Do you want to use a collection to update a sharepoint list?

If you use Collection to update, you need to make sure:

1)all the field names are the same in two sides

2)all the field data type are the same in two sides

It seems like your situation is not like this.

So I suggest you use ForAll and Patch to update.

Could you tell me the field data type in sharepoint list?

I assume that they are same as your fields in your collection.

Then try this:

ForAll(LocalCollection Patch('DN-OK', Defaults('DN-OK'), {field1inlist: ColumnA,field2inlist: ColumnB,field3inlist: ColumnC,field4inlist: ColumnD,field5inlist: ColumnE,field6inlist: ColumnF,...} ) )

To sum up, in this solution the two sides' fieldname and data type could be different.

Here's a doc about how to updating multiple line in details for your reference:

https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/

Best regards,

Was this reply helpful? Yes No
Suni 39 on at

Like (0)

Report

The field types shouldnt change (at least not intendet). I use ClearCollect() to import from SharePoint into the app. After that, all I do is EditForm. The SharePointList contains a mix of 'single line of text', 'multiple lines of text', 'Yes/No' and 'date and time' fields.

The ForAll() Solution looks easy to implement for me. It will simply copy the value of the CollectionField 1x1 into the SharePointField 1x1, 1x2 into 1x2 and so on?

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (0)

Report

Hi @Suni ,

Yes. If you use ForAll and Patch, you could copy data from collection to sharepoint list.

You need to point out which filed is used to update which field.

The field in collection could be used for multiple times to update sharepoint list.

I suggest you read this blog in details:

https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/

Best regards,

Was this reply helpful? Yes No