I want to add another DataTable to the DataTable

(0) Share

Report

Posted on by 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.

Categories:

Power Automate Desktop

I have the same question (1)

All responses (21)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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/1323354

-------------------------------------------------------------------------
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.

Was this reply helpful? Yes No
mao2 37 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
mao2 37 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
mao2 37 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

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! 🙌

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
mao2 37 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
mao2 37 on at

Like
a
(0)

Report
Copy link

Link copied!

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"}]}

Was this reply helpful? Yes No