Answered

All collection items and columns into ONE field

(0) Share

Report

Posted on by wwmn

103

I have an app for ordering supplies. When a user clicks add on an item it sends that items info to a collection. Each item in the collection has columns for;

NSN

NOMEN

QTY

PRICE

When someone places an order, that collection is exported to a CSV through PowerAutomate. It also records the order in a sharepoint list. I would like to patch all items selected to one multi-line text column, called c_ITEMS, for that particular SP list item, so that it looks like;

NSN, NOMEN, QTY, PRICE

etc.

I tried to use Concat, but I was only able to select one column from the collection. I'm unsure how to display all columns for each item.

Categories:

General Questions

All responses (3)

Answers (1)

Verified answer

WarrenBelz 146,603 Most Valuable Professional on at

Like (0)

Report
All collection items and columns into ONE field

Hi wwmn

This would put all fields and records into the format you posted in one column
Concat( CollectionName, NSN & "," & NOMEN & "," & QTY & "," & PRICE, Char(10) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
wwmn 103 on at

Like (0)

Report

All collection items and columns into ONE field

@abc 123

Actually I have considered this, I was just hoping there was a more direct or "correct" way.
Suggested answer

abc 123 784 Super User 2025 Season 1 on at

Like (0)

Report

All collection items and columns into ONE field

In the SharePoint list, and MLOT has the property called "Append Changes to Existing Text".

I suppose that if you turned that on, then you would need to concatenate anything, just patch each item in the collection to the column.

So, do one patch to add the new Record, then do a ForAll( Patch() ) that writes every row in the collection to the self-appending MLOT.

(This is a total hack, and I will never admit that I suggested it, but it should work.)