Skip to main content

Notifications

Community site session details

Community site session details

Session Id : xO5K9bQkNjNs17Ds7miUgu
Power Apps - Building Power Apps
Answered

List collection records into datacard text value

Like (0) ShareShare
ReportReport
Posted on 4 Apr 2019 18:59:28 by 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:
  • lumberjacklurch Profile Picture
    435 on 11 Apr 2019 at 18:18:53
    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 Profile Picture
    76,287 Super User 2024 Season 1 on 04 Apr 2019 at 20:15:35
    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 Profile Picture
    435 on 04 Apr 2019 at 19:06:50
    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))

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 230 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 110

#3
stampcoin Profile Picture

stampcoin 106

Overall leaderboard