Filter Data from TwoD array of Dictionary type

Help
1

Guys,Screenshot%20(1)
I used SharePoint custom activity for read a SharePoint list and a result is two dimensional array of dictionary<String.Object> type.

how filter specific data from this array?
Ex: there is a column - Status and with values - “Completed” and “Pending”
I want filter Completed data from the dictionary

Are there any method to resolve this problem?

2

Hi @RasinduLakkitha95 did you find how to solve this? I am wondering the same in this moment.

3

Hi @carmen,

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.
Ex:- SMARTCAML

cml1
cml1782×532 13.3 KB

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…

cml2
cml2784×532 25 KB

Afterthat copy following xml and then paste in sharepoint readlist activity

cml3
cml3888×534 36.3 KB

like thiscml4

Now you can create table like sharepoint list using build data table activity like following image.

cml7
cml7996×654 26.1 KB

then use for each activity with Argument type => Dictionary <String,Object>…

cml6
cml6996×682 32 KB

in For each use add data row to insert data from dic to table…

cml8
cml81038×674 39.5 KB

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

cml9
cml91366×768 76.4 KB

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
Datatablename.Rows(Rownumber).item(columnname).tostring

2 Likes
4

Hi @carmen,

02)Without CAML

you can get data from sharepoint to data table using above procedure except caml query… after that you can use filter data table to filter data…

thats it… hope got resolved you problem
cheers

1 Like
5

Also You can use this documentation

SharePoint_Custom_Activities_Documentation.pdf (1.5 MB)

6

thank you very much! That is all that I was needing to know.

1 Like
7

Hi @RasinduLakkitha95, thank you! Your solution helped me as well. Is there also another way to update a list item in Sharepoint without CAML? because I’m not familiar with CAML.

Regards