Answered

Problem with collection - Shopping Cart

(0) Share

Report

Posted on by mat4

Hi,

I have a problem with a collection. I have built something like a store for employee shopping. The products are collected in a collection. The collection with a button is sent to the list on SP.

1) How to give the same ID for the whole single collection ?
After submission, all products from the shopping cart are in separate rows. I need them to have one PO number.

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mat4 ,

It relies on how you update the collection to the list. Is PO Number a column in this list? What's the column type?

Generally speaking, before updating, you can use below formula to bulk update the collection and add a PO number in it:

UpdateIf(collection, true, {'PO number': ...})

But where do you get or generate the PO number of all items?

Best regards,

Was this reply helpful? Yes No
mat4 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni
Yes, PO is one of columns in sharepoint list.

In general, this does not have to be solved by adding the same ID to all items in the collection.
The question is whether it is possible to get a single PO number (for the whole collection) that is sent to the List as multiple rows.
The next order that arrives (also multiple items) should have a different PO (for the whole collection one)

Regards,

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mat4 ,

So, you need to generate the PO number automatically when submitting the collection, right? But what is the pattern of PO number generation? You can either create it anywhere in your App and save it in a variable, use it in Patch or use a set of static texts directly in Patch function for the PO number columns.

Best regards,

Was this reply helpful? Yes No
mat4 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni,

The pattern of PO is combination of standard ID number + phrase"/WESS" e.g. 11/WESS.

Best Regards,
Matthew

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mat4 ,

Then where does the standard ID number come from? Can you have the PO number before submitting the collection?

Best regards,

Was this reply helpful? Yes No
mat4 25 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni
I do not have any ID for the PO. I tried adding a value of "1" to a column in the collection but there was no increment of this value in subsequent records.

Regards,
Matt

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mat4 ,

OK, then you can generate the number automatically using below formula, and use it when submitting the collection:

Set(varPO, Concat(Add(First(Split(Last(SPlist).'PO Number'),"/"),1),"/WESS")); Patch(SPlist, ForAll(collection, {'PO Number': varPO, Quantity: ThisRecord.Quantity}))

The variable is getting the PO Number from the last item of your list, split the value with / to get the number, add 1 to it and concatenate with "/WESS" to generate the new PO Number. Then this variable is used in the Patch function to update the value to list.

Best regards,

Was this reply helpful? Yes No
mat4 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear @v-jefferni

Function "Add" is not recognized

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mat4 ,

Sorry, my fault. Try below:

Set(varPO, Concat(Text(First(Split(Last(SPlist).'PO Number',"/")).Value+1),"/WESS")); Patch(SPlist, ForAll(collection, {'PO Number': varPO, Quantity: ThisRecord.Quantity}))

BR,

Was this reply helpful? Yes No
mat4 25 on at

Like
a
(0)

Report
Copy link

Link copied!
Dear @v-jefferni ,

I'm trying but i have some errors:
Set(varPO;Concat(Text(First(Split(Last('Zakupy pracownicze - zamówienia').'Numer zamówienia';"/"));Value+1);"/WESS"));

Was this reply helpful? Yes No