For each - decision based on content

Help
#1

Hi, could you help? using this data set how do i use “for each row” to invoke a workflow per PONumber (not per row) - any help gratefully accepted - Thanks

image

#2

Hi @EugeConn
suppose loop is at first row , you don’t want to invoke the workflow right you want to invoke the workflow at the latest matching ponumber , is it?

#3

If PONumbers are fixed,

then you can use switch activity and in each case invoke workflow for matching PONumber.

Regards,
Karthik Byggari

#4

@Eugeconn

You can try like this

Let us take ur datatable as dta

dta= (From p In dta.Select
        Group p by PON=Convert.ToString(p("PONumber")) Into Group
       Select Group(0)).ToArray.CopyToDataTable

Now you dta will contain distinct rows of Column PONumber.

Now You can Run For Each and Invoke.

Regards,
Mahesh

#5

Hi Mahesh, please excuse the real rookie question - is your thinking to use UiPath Assign activity? if so - unfortunately I’m getting an “End of expression expected” error???

#6

@EugeConn
I have made changes to the previous query please check once.

Regards,
Mahesh

#7

Thanks Mahesh, much appreciated :wink: