Transpose DV row into a SharePoint list column

[Dartanian1975]

Hi 

I'm trying to build a flow to transpose a single row from Dataverse into a column in a SharePoint list. Like this: 

The Name column has the column names from the DV table. The DV row has a fixed number of columns and the list has the same fixed number of rows. 

The flow so far: 

Within the loop, I thought I could just use concat or similar text manipulation to reference dynamic content:  

outputs('Get_one_row_of_fruit')?['body/Col1']

But that's just a string, not an expression that can be parsed as far as I can tell.

Given there's no handy transpose() function yet, is there a way to do this?  

Thanks!

[v-jefferni]

Hi @Dartanian1975 ,

Please refer to below blog where has detailed steps of transpose columns:

https://immersivecoder.com/2021/08/29/transpose-table-columns-using-power-automate-with-example/

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[sheridannye]

Thanks @v-jefferni   for the link to the blog. Very nearly a solution 😉 However, the example is transposing from Excel, whereas I need to transpose from Dataverse. DV returns additional fields and formatting. The functions in the Compose actions don't strip out all the unnecessary characters, so the Convert to JSON Object action throws an error. 

Second issue is that some of the returned values are are empty, which also causes formatting errors. Could filter those out but there are over 40 of them... 

I'll work on it a bit more to see if tweaking the compose expressions can solve it. 

[evalindag]

Hi @sheridannye 

Did you find the solution for this?

Best regards