How to build a data table from the list of retrieved records using Query Entity Records (Data Service activity)?

Help Data Service
,
1

Hi all,
I am struggling with the following problem.
I am retrieving data from the data service entity using query entity record activity.
the output is in the form of IList. (System.Collections.Generic.IList) But I want to build a data table from this IList. Any help is much appreciated.
Thanks.

2

@arpithaj17

Have you tried using the Build Data Table activity for the DT?

3

Yes. I am facing problem while populating values. Finding difficulty in assigning values from IList from data service to datatable columns.

4

Please see this sample from Karan which converts the List returned from Data Service to a Data Table - Export data service list into a excel sheeet - #4 by Karan

He is also writing the data to Excel but you can ignore that part.

5

HI @arpithaj17 ,

I have attached a sample flow which retrieves data from data service using “Query Entity Record” Activity and saves it in a data table.

For testing I have created an entity Employee in data services as below.

Employee
Employee1759Ă—771 65.7 KB

DataServices.zip (6.0 KB)

Thanks,
Kapil

1 Like
6

Thanks for the help. Solved my problem.

7

Thanks for the help.

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.