Patch Collection to Single Row in SharePoint

[drewdev]

Hello,

I'm looking to take my collection (that has several rows of data) and patch it to a single row within a separate SharePoint data source.

I can use either Patch or Collect and reference the Collection and it saves to SP just fine, but always adds multiple rows. 

I need only a single row of data to track changes to fields. Every time certain fields change, I have the On Change to collect each value and store it in the collection, I then need to take this whole collection and save as a single row in SP with an ID listed.

Any thoughts on how to accomplish? I feel like it's something very simple I am missing and just can't figure out what formula to write.

Thanks so much!

[Nogueira1306]

Patch(

//Item from Collection (you can use a LookUp, for example) ,

Defaults(YourDataSource),

{

...

}

)

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-patch

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!

My blog!

[Drrickryp]

@drewdev 

Use Concat() to convert a table into a single row of strings

Concat(yourcollection, Value, ", ")

You can replace Value with the name of the column in your collection that you want to convert to a string.

so

Patch(splist, Defaults(splist),{somecolumn: Concat(yourcollection, Value, ", ")})

[drewdev]

So I saw Concat.. but wasn't sure how to write the Value piece.. I need to concat every row vs. a few fields - is there an easy way to write this so I dont have to write out every single field? (there is like 10-15 fields so trying to avoid this and just have it automatically convert the entire collection to a single row)

[drewdev]

This is patching to an already existing value in SP.. not what I need to do unfortunately as the new row is being created with a button within PA 

I need to write all values from Collection to a single NEW row within SP - hope that helps clarify.

[Drrickryp]

@drewdev 

Please post a screenshot of your collection 

[drewdev]

So I have this collection being populated - I need both rows to be combined so that the 3 possible fields all save to SP in one row:

Actual Monthly Volumes 

Forecasted Monthly Volumnes

Intake_ID

Right now it saves to SP as 2 rows vs just a single one. Hope this helps!

[Drrickryp]

@drewdev 

Does this work?

 Concat(
         colBenefitChanges, Concatenate(
                                         Actual_Monthly_Volumes, ", ",
                                         Forcasted_Monthly_Volumes, ", ",
                                         Intake_ID
                             ),";"
)

[cwebb365]

I would just use the JSON function. You can just feed it the collection and it will dynamically put it to Text. Althou it's in JSON format, but it makes it usable if you need to reference in Flow or other API's etc. There is the new ParseJSON() function as well (Experimental) that you can use to Read JSON back into collections etc. 

That's how I've been handling things like that. Makes it dynamic and reusable. Anyway, hope this helps.  

Also, be mindful of your max character limits in your column you save this data. You can only store so much into SharePoint columns. 

[drewdev]

I'm not seeing how that would apply the item directly to the SP list 

Here is what I'm using to get the collection into SP: 

Patch(SPList,colBenefitChanges)   

or

Collect(SPList,colBenefitChanges)

This submits the entire collection into separate rows, where would I include the Concat piece? I tried copying what you had and got an Expected Record error.