Active Directory- Get Object Properties For Each Data in Excel

Help Studio
, ,
1

Hey guys,

I’m trying to get some values in my excel DataTable with Active Directory-Get Object Properties activity. But when I try to get values from excel data , it gives error for me on for each side.

Is there any suggestion , how can I get values and convert them to for AD Activity type in for each ?

Workflow ;

image
image581×589 19.8 KB

Variable Panel;

image
image746×141 4.18 KB

Thanks.

2

Hi,

I think DistinguishedName property will be the following.

cn("ColumnName").ToString

Please modify the above columnname to actual column which has dn.

Regards,

1 Like
3

Hi,

When I try it ;

image
image1920×1080 206 KB

My Data:

image

4

Hi @burakavuncu,

What’s the type argument you have selected for, For Each activity

Kind Regards,
Sanjit Pal

5

Hi,

image
image1920×1080 211 KB

Array of String

6

Change it to the IEnumerable data row and try the way as @Yoichi said, this might can solve the issue.

7

I try but same as before ;

image
image1920×1080 217 KB

8

@burakavuncu kindly follow this approach
image

1 Like
9

Hi,

Can you try to set just DataRow instead of IEnumerable<DataRow> at TypeArgument property of ForEach activity?

Regards,

11

Hey Mate,

Can you share excel template file too please?

Best regards,

12

Yea mate,
Active_Directory.xaml (15.7 KB)
sample.xlsx (11.5 KB)

My excel and my xaml .

It works by the way ,ı can pass now ı just need to write all outputs coming from “Get Object Properties” to excel. How can ı do that?

I need to write results to excel .

Thanks,

13

@burakavuncu there are multiple ways to do it but you can follow the below approach:

  1. Use a build datatable activity to create the datatable structure outside the for each loop.
  2. Inside the loop use add data row activity to add the value to the table
  3. After for each use write range activity and pass the datatable variable to that activity it will dump all the data to the excel file.
14

Hey Mate,

Could you send me example if you have ?

Cause when ı try it ı got error on add data row .

image
image838×293 8.66 KB

Error :slight_smile:

image
image1920×1080 201 KB

15

@burakavuncu PFA the example, this is just for reference
AddDataFromADToExcel.xaml (13.6 KB)