cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lumberjacklurch
Post Patron
Post Patron

List collection records into datacard text value

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.

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User III
Super User III

@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.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

3 REPLIES 3
lumberjacklurch
Post Patron
Post Patron

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

RandyHayes
Super User III
Super User III

@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.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

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.

 


 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (47,162)