cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
teqs
Kudo Collector
Kudo Collector

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
v-alzhan-msft
Community Support
Community Support

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
v-alzhan-msft
Community Support
Community Support

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.

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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Users online (3,694)