Unable to display text from people picker/lookup column in HTML table.

[Anonymous]

Hello,

This is my first post here. Please excuse any lack of information, I'll be happy to provide whatever is needed.

I was following this tutorial by the very talented @RezaDorrani where he builds a HTML table with different types of columns. I'm able to get proper text values to be displayed from all columns except people and choice columns. Flow runs as expected but information is displayed like this:

(choice column is on the left, people lookup column is on the right)

As you can see, I'm unable to get the value of my choice column. The dinamic object created by my Get Items does not allow me to get the specific value of the column.

(here you can see there's no 'value' for the "Tipo Impacto" choice column)

I've tried parsing the column using a JSON schema, but doing so results in the following error:

"BadRequest. The property 'columns' must be specified unless the 'from' property value is an array of objects."

Here's that error:

Finally, here is my entire flow:

Hope that's enough to start with. Thanks in advance for your time!

Cheers.

[PrasadAthalye · Accepted solution]

For the People picker,

You will have to select Display Name Property. Refer example of Created By

In your screen shot, I can see value property for Tipo Incidencia. 

Did you allow multiple values in Tipo Impacto? If yes, that is a collection and will be a tricky one.

[Anonymous]

Hey there! Thanks for taking the time to take a look at my flow.

When looking for the DisplayName of 'Usuario afectado', there's no dynamic content being generated from my "Get Items" step (first of the list).

However, it is possible to assign the Display Name property of 'Usuario afectado' from my Update Items step. Doing so will put the entire "Create HTML Table" step into an Apply to Each loop, and running the flow will result in an error:

"e is undefined"

In regards to the choice column...

Yes, the value for Tipo Incidencia does show up as dynamic content and it is displayed properly in the table. But Tipo Impacto does not display its value as dynamic content. Here's what I mean:

(Get Items's dynamic content highlighted in yellow)

Very similarly to the People picker, I can pass the whole of Tipo Impacto, but not its value. Doing that produces the undesired result shown on the OP. If I use the dynamic content from any other steps, an Apply to Each loop is created and I get the following error:
"The execution of template action 'Aplicar_a_cada_uno_2' failed: the result of the evaluation of 'foreach' expression '@outputs('Actualizar_elemento')?['body/TIpo_x0020_Impacto'] is of type 'Null'. The result must be a valid array."

Please let me know if I made myself clear! Thank you again!

[Anonymous]

I looked into the properties of my column "Tipo Impacto" in Sharepoint.

You were right! It was configured to allow multiple values to be chosen. This is not needed for my use case so I changed it to act as a drop down menu instead and now I can select that value from the dynamic content menu in my flow and the value is properly displayed in my table.

This promted me to do the same for the People picker and now I am able to get the dynamic content for the Display Name of Usuario Afectado, but in this case I would like to be able to set multiple people in my Sharepoint column and get all their names to display in my HTML table.

You mentioned this means we have to work with collections. I'll do my own research on the topic, but if you have any advice that would help me to achieve this I would highly appreciate it!