How to use a string value from a Column from a Datatable that has been Grouped?

[JayBee]

Hi,

I hope someone could help as its really got me stuck on this project.

I’ve grouped some data together via there order number as you can see hightlighted below;

so in this example there is 3 ‘groups’

i’ve done this through a For Each activity.

Now i’ve tried to use a Type Into activity within the For Each loop to input the string value from Column F as i only need to do this once for each group.

But i get an implicit error stating i cannot convert from “String” to “Integer”.

Can someone please help me with this?

I would upload the workflow but it will not allow me.

Thanks

[ppr (Peter Preuss)]

is a forked duplicate question from below and is ansered in origin topic thread

How to use For Each Loop against a specific value, not each row of a datatable?

ppr thank you so much my friend. Just tested the grp.First()(XXXX).ToString and its worked just as I had hoped. Again, thank you. you have saved me a great deal of headache and I can now move onto the next step of the process. I will test the for each row function now but i’m confident I can get that part working fine. was just the getting the lines grouped that was my biggest problem! and thank you @supermanPunch for trying to help in the first instance. I will try my best to learn and im…