web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Getting values into si...
Power Apps
Answered

Getting values into single collection

(0) ShareShare
ReportReport
Posted on by 204

Hi All,

 

I'm Having a collection as shown below:

2.PNG

 

and again each value is having 2-3 values as shown below:

3.PNG

 

so i want to merge the two values into as sharepoint,nintex and save it to another collection

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Krishna98 

    You can consider the following Formula:

    ForAll(NCol,
     ForAll(Value,
     Collect(NewCollection, Value)
     )
    )

    This will give you a new collection with the values you are looking for.

     

    I hope this is helpful for you.

  • Krishna98 Profile Picture
    204 on at

    Hi @RandyHayes 

     

    Actually i need it into single column like 1st table values into one single value and next table into another single value like that

  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Krishna98 

    Got ya...then in that case, this would be more of what you are looking for:

    ClearCollect(NewCollection,
     ForAll(NCol,
     {Value: With({v:Concat(Value, Value & ";")}, Left(v, Len(v)-1))}
     )
    )

     

  • Krishna98 Profile Picture
    204 on at

    Thank you so much @RandyHayes . it worked at best.

    can you please explain how it works

     

     

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Krishna98 

    Sure, it uses a ForAll to loop through all of the rows in your NCol collection.  ForAll Returns records in a table, so we can just define the record we want to return - which we do in the { } section.

    In that section, we define a record with a Value column.  Then we apply the Concat formula to put together the Value in the NCol Value in a semicolon separated format.  Then we apply that to a With variable (v) so that we can ultimately return just the value without the last semicolon - Left(v, Len(v)-1)

    That will then be the ultimate value of our Value in the record we are creating in the ForAll.  

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 534

#2
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard