Create HTML table from a single List record

[shoebwk]

I am struggling to create the HTML table when a single record is selected in Get Item. Not sure if there is any additional steps to perform before the HTML steps. 

Thank you for your support

FlowError

[v-litu-msft · Accepted solution]

Hi @shoebwk,

Cause the input of Select action should be an array, so we should put the body of Get item into the array variable, please following steps as below:

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

[shoebwk]

Thanks for the solution.

Is it possible to transpose the table so all headings are in first column?

Title

Requestor

Change Reason

Change Type

Scope of Work

Change Benefit

External Supplier

CR Start Date

CR End Date

Total Man-Days

Cost Impact

Reviewed By

Reviewed Date

Reviewer's Decision

Reviewer's Comment

CR Status

Post CR Updates

Storage Refresh Unity 380

Khan, Shoeb (AE/GFI)

Replace old storage

Hardware Lifecycle

ABC DEF GEH 3456

More Space 3 year warranty Fast drive 1234

1234

2020-08-04

2020-08-31

51

111

Shoeb Khan

2022-01-07

Approved

Ok, Approved

[irbandit]

Did anyone ever figure out if there was a way to transpose the heading and have the values next to them?

[Kawalpreet]

Steps:

1) Get item

2) Add Select (from actions)

• In "From" section - enter an expression as "array(outputs('Get_item')?['body'])
• Click OK
• Now enter header values in Map section and select the column names that you want to show in the table

3) Add Create HTML Table (from actions)

4) You are done 🙂

[cb23]

Hey, did you work out how to transpose easily? @v-litu-msft's solution worked for me but switching it up so that the headers are on the left and answers on the right would be a gamechanger! 

[gauravk1]

Thanks It worked in my case.