Patch collection information to a sharepoint list column

[FuadJabbr]

Hi

Would it be possible to patch the information in collections and put those information into a single multitext column in sharepoint list

I am trying to create a Office stationary request app, where when the items are ordered, it goes to a sharepoint list as separate rows, which I was able to achieve, However I want the consolidated list of items, in the collections, to go to another sharepoint list which we use as a tracker.

So basically, we have to sharepoint list, One is used to get all the individual items and the quantity and another one, which is a tracker that sends out email to the user saying these are the items that you are ordered( I can do this part only if I can get all the collection information into a column that we have.

I have a collection by the name "stationary" which has 3 fields - Items, Category and Quantity.

Apologies if my question is not clear. Do let me know if you need more clarifications

[StalinPonnusamy · Accepted solution]

Hi @FuadJabbr 

Yes, we can convert the collection to text. And here is my Sample

ClearCollect(
    ColRequestItems,
    {
        Items: "Item 1",
        Category: "Cat1",
        Quantity: 10
    },
    {
        Items: "Item 2",
        Category: "Cat 2",
        Quantity: 2
    }
);

Set(
    varString,
    Concat(
        ColRequestItems,
        Concatenate(
            "Items:|",
            Items,
            "|Category:|",
            Category,
            "|Quantity:|",
            Quantity
        ),
        ";"
    )
)

Thanks,
Stalin - Learn To Illuminate

[FuadJabbr]

Thank you very much. This worked. Just trying to figure out how to get a next item to go on a new line