Announcements
Hi All,
I'm Having a collection as shown below:
and again each value is having 2-3 values as shown below:
so i want to merge the two values into as sharepoint,nintex and save it to another collection
@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.
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
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))} ) )
Thank you so much @RandyHayes . it worked at best.
can you please explain how it works
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 534
WarrenBelz 416 Most Valuable Professional
Valantis 306
