Multiple Values from Collection into a single Field

[danniaus1]

Hi Everyone

I have a collection with multiple rows

View attachment 1560146473985.png

I want to save the values from NMI into a single row in my main collection so they appear like this in the field

VE....., 64......

So I only end up with a single line of data in my main collection.

I am not having much luck with my calculations, string is new to me and I am spending alot of time googling but nothing is making sense

Thanks in advance

 

[Sachin_Kharmale]

Hi,

You need to design flow like bellow,
View attachment 1560166854824.png

1.Loop your input collection
View attachment 1560167115626.png
2. Take one Text Data Item and append NAM filed value in using calculation stage in loop.
View attachment 1560167146390.png
3.when Loop will end Remove all rows of the input collection.
View attachment 1560167224126.png
4.Then Add new row to the input collection.
View attachment 1560167249162.png
5.Copy Data item value into the input collection field.
View attachment 1560167286257.png

Then you will get result like ,
View attachment 1560167338566.png

I Hope it will help you.

Best,
Sachin

 

[danniaus1]

Thankyou Sachin, this worked a treat Really appreciate it

 

[danniaus1]

Thankyou Sachin, this worked a treat Really appreciate it

Hi,

You need to design flow like bellow,
View attachment 4006

1.Loop your input collection
View attachment 4007
2. Take one Text Data Item and append NAM filed value in using calculation stage in loop.
View attachment 4008
3.when Loop will end Remove all rows of the input collection.
View attachment 4009
4.Then Add new row to the input collection.
View attachment 4010
5.Copy Data item value into the input collection field.
View attachment 4011

Then you will get result like ,
View attachment 4012

I Hope it will help you.

Best,
Sachin