List collection records into datacard text value

Like (0) Share

Report

Posted on 4 Apr 2019 18:59:28 by lumberjacklurch

435

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.

Categories:

General Questions

All responses (3)

Answers (1)

lumberjacklurch 435 on 11 Apr 2019 at 18:18:53

Like (1)

Report
Re: List collection records into datacard text value

Thanks Randy. I think I was overthinking it with the ForAll.
@RandyHayes wrote:
@lumberjacklurch

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.
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on 04 Apr 2019 at 20:15:35

Like (0)

Report
Re: List collection records into datacard text value

@lumberjacklurch

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.
lumberjacklurch 435 on 04 Apr 2019 at 19:06:50

Like (0)

Report

Re: List collection records into datacard text value

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))