cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate V
Advocate V

Transpose JSON Data or Transpose Create HTML result

Hello,

 

I struggle to get a transposed "Create HTML table".

Transpose means something like rotate: Coloums of should be rows and rows shoud be coloumns. 

 

(Excel Example to show transpose: https://support.office.com/en-us/article/transpose-rotate-data-from-rows-to-columns-or-vice-versa-34... )

 

I know there is also a CSS/Stylesolution to transpose a HTML table itself, but it is only a bad workarround which is only working for really simple and small cells. In my case the CSS/Style solution solution do not work.

 

I needed a full day to even parse a dynamic JSON, solution with credits linked here: https://powerusers.microsoft.com/t5/Building-Flows/Parse-dynamic-JSON-for-every-array-element-and-ev...

 

But I still struggle to build the transposed Data. It's not as easy as it sounds. Because data structure are different. Also JSON array of elements can miss a property in some array-elements, which other array elemenst have (if the property value is null/empty). I run into a big bunch of problems.

 

Perhaps I am searching in a wrong direction and someone knows a much better way.

I can think of three solutions:

1. Transpose the JSON Data, before hand them over to official "Create HTML Table" Connector. (Would be best idea, but I do not get managed to transpose JSON in flow)

 

2. Transpose the result of "Create HTML Table" Connector. (Would be also a good idea, but I do not get managed to transpose the

HTML Table in flow)

 

3. Parse the JSON by self and create a own  "Create transposed HTML Table"-Connector as Flow per HTTP-Trigger. I tried, as you see in the other thread, even the parsing of the dynamic JSON was hard.

 

Someone knows of a easier idea?

 

Thanks a lot and best regards

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Transpose JSON Data or Transpose Create HTML result

Hi @teqs ,

 

I‘m afraid that there is no any way could transpose the result of "Create HTML Table" Connector in microsoft flow currently and there is no any easy way to achieve your requirement. I suggest that you could take a try with your third solutions.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Transpose JSON Data or Transpose Create HTML result

Hi @teqs ,

 

I‘m afraid that there is no any way could transpose the result of "Create HTML Table" Connector in microsoft flow currently and there is no any easy way to achieve your requirement. I suggest that you could take a try with your third solutions.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Advocate V
Advocate V

Re: Transpose JSON Data or Transpose Create HTML result

If someone comes across this, here is a official idea about that feature:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/A-possibility-to-transpose-rotate-quot-crea...

 

I tried much workarounds, but having something which worked good for any table, was not possible. I hope to see such a valuable feature.

 

 

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (8,057)