HTML Table from Parse JSON

[GABRIELV221]

Hi folks!

I need get all items, with some filters, from Sharepoint and group by Created by. For each "Created By", create a table with the list of items and send an email to each "Created By".

I'm trying to create a HTML Table from Parse JSON in my flow to send an email.

I GET my rows from a SharePoint List.

When I try this, I've this issue: The 'from' property value in the 'table' action inputs is of type 'Null'. The value must be of type 'Array'.

I tried with a Select before, but the error is the same.

[Expiscornovus · Accepted solution]

Hi @GABRIELV221,

With the nometadata accept header the results would be in the value property (array) within the body. You could even directly use that value property in your Create HTML table or Select. You actually would not need a Parse Json for this.

Try and add the expression below via the expression editor in the From field:

body('Send_an_HTTP_request_to_SharePoint')['value']

[GABRIELV221]

Good point @Expiscornovus , this works but now I cannot see only names or emails in "Person or Groups" fields.

I'd like to have one column with Title (Display Name) and other with the email.

Example:

[Expiscornovus]

Hi @GABRIELV221,

You can solve that by selecting that in your REST API call. You could use a $select=InnovationChampion/Title,Author/EMail in your GET request.

[GABRIELV221]

Yes, I have these field in my select. Title and Email for both fields...

But when I create the HTML Table, this step put these field under one column... Like "Author" as column and in the row value "Title and Email" in the same place...

[Expiscornovus]

Hi @GABRIELV221,

Yeah, I see what you mean.

In that case use a Custom Columns setup instead of an automatic one.

Try something like below:

item()?['Author/EMail']