Concatinate values from my Power App into a SharePoint list.

[golfnutt82]

Hello,
Kind of frustrated here.
Is it possible to write to a Summary field all items that were ordered from the Office Supply Products list to the Office Supply Orders list.
This is the list showing the summary field.

I have an "Place Order" button that uses the below logic

Set(
varShowSpinner,
true
);
Set(
varRecordID,
Patch(
'Company Store Orders',
Defaults('Company Store Orders'),
{
'Order Total': With(
{
ST: Sum(
colShoppingCart,
SubTotal
)
},
ST + ST * .06 + 4.99
),
'Order Comments': txtComments.Text,
Title: txtName.Text
}
).ID
);
ClearCollect(
colOrderedItems,
AddColumns(
colShoppingCart,
"OrderID",
varRecordID
)
);
Collect(
'Company Store Orderd Products',
colOrderedItems
);
Navigate('SN Office Supply Orders Screen');
Set(
varShowSpinner,
false
);

Can I modify this to do what I want

[golfnutt82]

So, I found out that this is an older sharepoint solution that is being migrated to SPO.
Here is the JavaScrip custom page showing how they are ordering supplies.

When the form is entered it shoves everything into this list as I have shown before.

I was thinking I could use a Gallery but I am not sure How I can do the same thing shown above?
Please offer any advice, suggestions or any help if possible.
Thank you!

[BCBuizer]

Hi @golfnutt82 ,

Not exactly sure how your data structure looks, but my first guess on how to create the value for the 'Order Summary' column looks like the below:

ConCat(
	colOrderedItems,
	$"Id: {Id} - Title: {Title} - Quantity: {Quantity}",
	Char(13)
)

It uses string interpolation to create the lines and the Concat function to combine all the lines, separated by a line break.

I didn't see any Patch function that saves to the 'Office Supply Order' list, so you probably need to insert that and use the above code for the 'Order Summary' column.

[golfnutt82]

Hi BC,
I have two Collections.

When I move the quantity slider it hold a count and a + sign shows up to the right.
I click the plus sign and it adds the item to the shopping cart to the right and then clears the selected item on the left.

When I click check out the following screen appears.

These are the products sitting in my cart where I can edit the count or delete the item.
The ordered item list holds the email address of the user and any notes/comments but they are not here yet as I havent figured out how to add them because the connection to that list and form are not present here.
When I select Place order I was hoping that the colOrderItems collection can be modified to work with what I have but being somewhat new to this I am a bit lost.
Here is the formula behind the "Place Order" button. 
I am trying to sum the count of items orderd.
I may not need this as the order summary field shows the ID of the item, Title and Qty
In this older formula it was written to write into another list one line item for each item ordered, which is not what I want as shown by my previous post showing the lists.
Hope this helps.

Set(
varShowSpinner,
true
);
Set(
varRecordID,
Patch(
'Office Supply Orders',
Defaults('Office Supply Orders'),
{
'Order Total': With(
{
ST: Sum(
colShoppingCart,
SubTotal
)
},
ST + ST
),
'Order Summary': txtComments.Text,
Title: txtName.Text
}
).ID
);
ClearCollect(
colOrderedItems,
AddColumns(
colShoppingCart,
"OrderID",
varRecordID
)
);
Collect(
'Company Store Orderd Products',
colOrderedItems
);
Navigate('SN Office Supply Orders Screen');
Set(
varShowSpinner,
false
);

[golfnutt82]

Here is the formula with what you provided.

The Id number you are referencing in your concat function is the Id number of the item located in the Office Supply Items list.

[golfnutt82]

Modified

When I look at the list I found that 'field_4' is the Order Summary field in the Office Supply Orders list.

[BCBuizer]

Hi @golfnutt82 ,

It seems the closing bracket for the ConCat function is missing after Char(13).

[golfnutt82]

HellO BC,
I have come to the conclusion that updating a SharePoint Orders list item where the field Name is Order Summary with each ordered item as follows is not possible. I will need to use Power Automate to update the Order Summary field.
Thanks for your help.

[golfnutt82]

I had posted this twice in a couple different ways to hopefully get more engagement from the Power App community.
I recieved a couple responses, which was awsome but after much trial and error I found that I could not solve the problem in that I believe I needed to build a new collection but looping throug another collection. I found that looping through a collection isnt supported. So, in conjunction of the Power App and the help of Power Automate, 

[BCBuizer]

Hi @golfnutt82 ,

Not sure why you came to the conclusion it is not possible to do this in Power Apps. Using the ConCat function, this is entirely possible. Happy to continue working to finding a solution if you wish so.