cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FuadJabbr
Regular Visitor

Patch collection information to a sharepoint list column

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

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Super User
Super User

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
        ),
        ";"
    )
)

 

StalinPonnusamy_0-1643296812592.png


Thanks,
Stalin - Learn To Illuminate

View solution in original post

2 REPLIES 2
StalinPonnusamy
Super User
Super User

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
        ),
        ";"
    )
)

 

StalinPonnusamy_0-1643296812592.png


Thanks,
Stalin - Learn To Illuminate

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

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Top Solution Authors
Top Kudoed Authors
Users online (2,552)