Store dictionary 2 type data into data table format

[bhala (bhalachanndra)]

i am using camel query in share point and output of that is in dictionary 2 format ie (system.collection.generic.dictionary<system.string.system.object>format…i want to store the result of that output in the readable format or in the data table format …how can i do that

[bhala (bhalachanndra)]

this is how i done…but i want to show the data or store the data…
this is variable of read list item

[supermanPunch (Arpan)]

@bhala You’ll need to Loop through the resultdt using for Each,
Make Type Argument of for Each as Dictionary<Of String, Object>, then Using the Field Values from the Sharepoint you can access the values inside the For Each in this way :
item(“FieldName”).ToString

Try to Implement it in this way

This Post Might give you more Details about it :

How to get LookupID in sharepoint list

I installed the UiPathTeam.Sharepoint.Activities.1.3.0.nupkg. And then I used update list items activity in this package to update list items, but there’s a problem when I try to update “Lookup” type column. How can I get the LookupId from the lookup list. [image]

[bhala (bhalachanndra)]

plz ellaboratate for each …but i dont have data table variable and for each we need it…

[supermanPunch (Arpan)]

@bhala Do you know the Field Names present in the Sharepoint?

[bhala (bhalachanndra)]

yes i know

[bhala (bhalachanndra)]

i just want …what i have brought the result from the sharepoint ,it should be seen or stored somewhere

[supermanPunch (Arpan)]

@bhala In this xaml, there contains a ForEach, Paste that ForEach in your Workflow after Read List Items.
justForEach.xaml (5.2 KB)

[bhala (bhalachanndra)]

whwn i pase it in

[AshwinS2 (Ashwin S)]

Hi @bhala
Use Microsoft.activities.extensions package please do install

Thanks
Ashwin S

[supermanPunch (Arpan)]

@bhala Ok Then Delete it , I will tell what you need to Do

1. Use For Each Loop after Read List Items
2. Change The Type Argument to Dictionary<String,Object>
3. Inside body of For Each use a Message Box, with value item(“FieldName”).toString

This Should Work

[bhala (bhalachanndra)]

no sir im nor getting …how to change argument to dictionary <string,object>
and for each i havent input data table variable…

[AshwinS2 (Ashwin S)]

Hi @bhala

use for each item and change type as dictionary(of string,object)

and print the item as item(“Field name”).ToString

Thanks
Ashwin S

[bhala (bhalachanndra)]

i dont know how to change argument…

[supermanPunch (Arpan)]

@bhala Check the Screenshot, Click On Browse For Types in ForEach Type Argument :

[supermanPunch (Arpan)]

@bhala Then Select this by Typing in Search Bar Like Below :

Click on Ok After doing this Step

[bhala (bhalachanndra)]

yes sir…getting…but we have read list output is result

…we ineed input data table variable…ie result of read list

[supermanPunch (Arpan)]

@bhala Do not use For Each Row, Use For Each

[bhala (bhalachanndra)]

now this error is shown

[supermanPunch (Arpan)]

@bhala Can you show me What you are performing inside a For Each ?