Create HTML table is in Columns not rows (power app) - what is the css for this? any hints

[Mia_]

Hi,

I have seen some other suggestions for this but I'm struggling

I have no idea how to get this output in ROWS rather than 

X

X

X

X

Currently it's in columns

X   X   X     X

I looked at some other solutions but they're not simple (?)

What is an easy css? or other solution to put this into ROWS?

Any ideas

The below didn't help me

(https://powerusers.microsoft.com/t5/Building-Flows/html-table-format-columns-as-rows/td-p/890868)

[Chriddle]

https://powerusers.microsoft.com/t5/Building-Flows/Compose-HTML-Table-with-02-columns-only-Column-1-...

[Mia_]

Thank you I had a look but the code there doesn't work for me. I'm also not too familiar with XPaths - is there some other way? Maybe can someone suggest it to Microsoft (?)

I did give it a go though - i.e. with my flow above but it didn't work - obviously because I don't know what I'm doing; i.e. 

Before the Create HTML I put this Compose 1  deleting the last line (priority and low) because i have only 2 lines

<table>
  <thead>
    <tr>
      <th>Request Created By</th>
      <th>Type of Work</th>
      <th>Priority</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>Sudhansu Choudhury</td>
      <td>Building Painting</td>
      <td>Low</td>
    </tr>
  </tbody>
</table>

I changed the Compose to Compose 1 but I still got errors on all of these suggestions

range(
	0,
	length(
		xpath(
			xml(outputs('Compose')),
			'//thead/tr/th'
		)
	)
)

first(
	xpath(
		xml(outputs('Compose')),
		concat('//tbody/tr/td[', add(1, item()), ']/text()')
	)
)

[Chriddle]

If you encounter a problem, you should post a description or screenshot of it, or the error message if there is one 😉

If your HTML is in a Compose with name "Compose 1", you obviously have to replace each occurrance of 

outputs('Compose')

in the expressions above with

outputs('Compose_1')

[Chriddle]

Another way to achieve this is the following.

I don't recommend this because CSV has its pitfalls (your data can't contain commas here).

(XPath and CSV are the ways I know of to get the object's keys.)

Create CWS table

outputs('Compose')

Create HTML table

From: (If there are always 2 key/value pairs, you can also replace this with the array [0, 1])

range(
	0,
	length(
		split(
			split(
				body('Create_CSV_table'),
				decodeUriComponent('%0A')
			)[0],
			','
		)
	)
)

Header "Key":

split(
	split(
		body('Create_CSV_table'),
		decodeUriComponent('%0A')
	)[0],
	','
)[item()]

Header "Value":

split(
	split(
		body('Create_CSV_table'),
		decodeUriComponent('%0A')
	)[1],
	','
)[item()]