I am trying to grab a list of records from a collection and make the list appear in a multi-line record in a SharePoint list.
So I have a collection, let's call it "col_ItemDescription. The table would look something like this:
Item Description Quantity
Item1 Descr1 4
Item2 Descr2 1
Item3 Descr3 2
I want to pull the collection records and make them a list:
Item1,Descr1,4
Item2,Descr2,1
Item3,Descr3,2
I then want to take that list and put it into a multi-line text value in a datacard. The datacard will then update the record in the SharePoint list via SubmitForm.
I've tried using ForAll and Concat to make the list, but it doesn't like my code:
ForAll(col_ItemDescription, Concatenate(Item & "," & Description & "," & Quantity))
Anyone have an idea on how I can make this work?
Thanks.
Thanks Randy. I think I was overthinking it with the ForAll.
@RandyHayes wrote:
Give this formula a try:
Concat(col_ItemDescription, Item & "," & Description & "," & Quantity)If this gives you any error, post back what the error is and what you are seeing on it.
I hope this is helpful for you.
Give this formula a try:
Concat(col_ItemDescription, Item & "," & Description & "," & Quantity)
If this gives you any error, post back what the error is and what you are seeing on it.
I hope this is helpful for you.
I realize I had the syntax a little wrong in my code. Here's the "fixed" code, which still doesn't work.
ForAll(col_ItemDescription, Concatenate(Item," ",Description," ",Quantity))
WarrenBelz
230
Most Valuable Professional
MS.Ragavendar
110
stampcoin
106