For each - decision based on content

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

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?

If PONumbers are fixed,

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

Regards,
Karthik Byggari

@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

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???

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

Regards,
Mahesh

Thanks Mahesh, much appreciated :wink: