Passing Out DataGrid as Datatable

Help Forms
,
1

Hello all,

I’ve seen topics on how to pass a datatable into a form DataGrid or EditGrid, but I was wondering how to pass out the DataGrid into some argument, like a datatable or a dictionary.
For example, I have a form for cases and users choose a violation number(1st column) and the number of cases(2nd column) that contain that violation number.

The DataGrid has the property name ‘cases’
Violation Number has property name ‘violationNum’
Number of Cases has property name ‘numCases’

I’d like to pass the inputted data to a datatable as shown below:

image
image1695×288 23.7 KB

But it comes out empty. Is there a way to do this? I know I can deserialize the JSON string output but I’d prefer not to, if possible.

I can also attach an example workflow if that’d help.
Thank you in advance!

2

Hi @snichola,
Welcome to the Community!
I could give you some theoretical information. But instead let ask one of our great user who have awesome experience with forms.
Let me call for @Vajrang.

At @Vajrang - sorry for calling you but I think you can explain this better that I :slight_smile:

3

@snichola since you have already mentioned that you dont want to deserialize json , I have not seen any solution for now to get data table out directly from forms .

Data in edit grid is represented as Json so we cannot directly get Datatable out

4

Ok, I’ll just deserialize the json output then.
Thank you for the help!