there are two methods to filter data from sharepoint when we use sharepoint custom activity.
01) Use CAML query
there are so many tools in net to generate caml query according to our requirement.
As example there is a column - Status and with values - pending and updated…and want filter updated data from sharepoint
Now we can use caml query like this…
Afterthat copy following xml and then paste in sharepoint readlist activity
Now you can create table like sharepoint list using build data table activity like following image.
then use for each activity with Argument type => Dictionary <String,Object>…
in For each use add data row to insert data from dic to table…
in above picture, Title,Lastname,profile are sharepoint column names.when you use sharepoint column names please get the like this,
Sharepoint List => List Settings=>click list name
then use the column name in browser
Use “Title” as column name not “First name”
finally you have a data table with data which are filtered from sharepoint list…
Now you can access specific Data like