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-3419f2e3-beab-4318-aae5-d0f862209744 )
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-every-key-value/td-p/385080/
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
