I want to add another DataTable to the DataTable

[mao2]

I may be wrong because I'm not good at English.Sorry.

I want to add another data table to the data table.

please tell me how to do it.

Thank you in advance. 

[v-jefferni]

Hi @mao2 ,

This is not supported. You can use a Gallery instead, it is supported to add a sub- Gallery in a main Gallery.

Best regards,

[Agnius]

This is the forums for Power Automate Desktop, so Galleries do not apply here.

However, it still is not supported in data tables. You could convert your child table to a JSON blob and add that to a parent table, though. See my replies under this thread on how to do that: https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Data-Table-to-JSON-object-in-PAD/td-p/132...

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

[mao2]

Thank you for your advice. However, since I am using my company's computer, it is difficult to use Gallery.

[mao2]

Thank you for your advice. I was able to successfully combine two data tables into one JSON.

However, a different problem occurred.

I want to get specific data from JSON, but I don't know how.

I want to do that using variables.

If you know of a better way, please let me know.

Thank you.

[mao2]

I now have data like this.

{"Table":[
{"date":"2023/01/01 0:00:00","day of week":"(Sun)","check":"holiday"},
{"date":"2023/01/02 0:00:00","day of week":"(Mon)","check":"holiday"},
{"date":"2023/01/03 0:00:00","day of week":"(Tues)","check":"working days"}]}

From here, I would like to put the contents of the Xth(variable) "check" into a variable called A.

[Nived_Nambiar]

Hi @mao2 

To retrive the first check value use something like this 

Assume the above json is stored jsonobj variable which is of custom object.

Now use below expression to determine the first check value

%jsonobj['Answer'][0]['check']

like that you can try for other values 🙂

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Agnius]

@mao2 , what @Nived_Nambiar suggested covers the syntax of how to retrieve values from a custom object. If this doesn't work, you might first need to use Convert JSON to custom object to actually have it formatted as a custom object and not just a JSON blob.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

[mao2]

@Nived_Nambiar ,@Agnius 

Thank you.

"Convert JSON to custom object" causes an error.

Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Additional text encountered after finished reading JSON content: {. Path '', line 1, position 20326.

I found that converting to Base64 might improve it,but I'm not sure.

[Agnius]

It may already be converted. Have you tried accessing the values as @Nived_Nambiar suggested above?

[mao2]

I tried it, but I get an error saying property "check" is missing.

I tried this↓↓↓

%jsonobj[2][0][0]%

And got a 'T'.

I think this 'T' is this(Table for T)↓↓↓

   ↓

{"Table":[
{"date":"2023/01/01 0:00:00","day of week":"(Sun)","check":"holiday"},
{"date":"2023/01/02 0:00:00","day of week":"(Mon)","check":"holiday"},
{"date":"2023/01/03 0:00:00","day of week":"(Tues)","check":"working days"}]}

[Nived_Nambiar]

Hi @mao2 

Actually correct answer should have been %jsonobj['Table'][0]['check']

Could you confirm above one is correct json structure ?

[mao2]

@Nived_Nambiar 

I tried it, but I get an error saying that the property 'Table' does not exist.😢

[Agnius]

It would be easier if you shared the entire object. But it seems like you might need to use %jsonobj[2][0]['Table']%.

However, it's pretty hard to tell. Can you share what the entire JSON object looks like?

[Nived_Nambiar]

Hi @mao2 

Agree with @Agnius  if you can share the complete json object which you are working it would be easy to determine the solution 🙂

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[mao2]

@Agnius @Nived_Nambiar 

I am very grateful to both of you for your cooperation.

I tried displaying the contents of the data in a message box. Please let me know if there is any other better way. 

[Nived_Nambiar]

Hi @mao2 

I tried this approach 

Ignore the first action: I have used set variable to consider the json as string format.

Then  to convert json to custom object i have used convert json to custom object , as you can see its output is stored in JsonDt variable.

Now to display the first check property under Table property, i have used below expression in display message box action.

%JsonDt['Table'][0]['check']%

I think that you have used the string json for finding the value.

Could you try by this approach i have suggested 🙂

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[mao2]

@Nived_Nambiar 

I tried your image and confirmed that it actually works.

But my code gives an error.And now I know the reason.

I looked at past replies provided by @Agnius and combined the data using the following method.

※Data1 and Data2 is DataTable

1.Set Variable

Put {{}} in NewVar

2.Set Variable

Put %Data1% in NewVar['Table']

3.Convert custom object to JSON

NewVar→Json1

4.Set Variable

Put {{}} in NewVar2

5.Set Variable

Put %Data2% in NewVar2['Table']

6.Convert custom object to JSON

NewVar2→Json2

7.Set Variable

Put %Json1 + Json2% in JsonDt

I thought I had succeeded in combining two pieces of data into one.

However,I noticed that there are two ['Table'].

I think @Agnius probably didn't convey what he wanted to convey.I'm sorry.

Could you please tell me what to do?

[Nived_Nambiar]

Hi @mao2 

doing above method as you suggested will results in creating a json string/custom object like this 

[{"Table":[{}]},{"Table":[{}]}]

assume there are some values in [{}] 🙂

Try like this 

It will merge two lists into one (in your case Data1 and Data2 ) and then then add it as Table property in json object

See how output would be looking like:

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[mao2]

@Nived_Nambiar 

I tried that, but it seems I'm wrong again.....😢

If Data1 and Data2 are DataTables,if you display NewVar,the result will be like this,

I tried @Nived_Nambiar's code and got this.

It seems that [] is doubled and the data is a little strange.