save multiple values in one row in a collection and patch to sharepoint

(0) Share

Report

Posted on by LisKr

304

Hello,

I built an app with multiple fields (comboboxes) and checkboxes next to them. I set the OnCheck and OnUncheck properties, so that if the checkbox is checked, the item from the combobox is saved to a collection (with collect function) and if the checkbox is unchecked, it is removed again. So far, so good.

My problem is that everytime a checkbox is checked, it always creates a new row in the collection, like this:

cmValue1	cmValue2
abc
	xyz

But I need everything to be in just one row, like this:

cmValue1	cmValue2
abc	xyz

I need it that way, because I'll patch it to a sharepoint list and there should be only one record per patch. Is there a way to achieve what I want? Also suggest anything without a collection, if there's something, please.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report
Re: save multiple values in one row in a collection and patch to sharepoint

Hello @LisKr ,

Is the number of columns fixed?
Can you try the following for adding a value to your collection:
//OnCheck If(IsEmpty(collectionName), Collect(collectionName,{ColumnName:"Value"}), Pacth(collectionName,First(collectionName),{ColumnName:"Value"})) //On Uncheck Pacth(collectionName,First(collectionName),{ColumnName:Blank()}))

Was this reply helpful? Yes No
LisKr 304 on at

Like (0)

Report

Re: save multiple values in one row in a collection and patch to sharepoint

Hi @DBO_DV ,
that's exactly what I needed. Thank you very much!

So the key to achieving that is basically Patch + First function combined. Didn't think of that before.

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report

Re: save multiple values in one row in a collection and patch to sharepoint

Happy i could help.

Basically you can see a Collection as a normal table. Power apps doesn't make any difference between Tables and collections. So every formula you can use on a table you can also use on a collection.

Was this reply helpful? Yes No
LisKr 304 on at

Like (1)

Report

Re: save multiple values in one row in a collection and patch to sharepoint

Oh, I didn't know that! I'm sure that will help me in the future 🙂

Was this reply helpful? Yes No