cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GABRIELV221
Helper I
Helper I

HTML Table from Parse JSON

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.

 

GABRIELV221_0-1663789409427.png

 

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'.

 

GABRIELV221_1-1663789559947.png

 

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

GABRIELV221_5-1663789713869.png

 

GABRIELV221_4-1663789673218.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

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']

 

 

nometadataheader.PNG



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

5 REPLIES 5
Expiscornovus
Super User
Super User

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']

 

 

nometadataheader.PNG



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


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:

GABRIELV221_0-1663792188698.png

 

 

Expiscornovus
Super User
Super User

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.



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


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
Super User
Super User

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']

 

authoremail.PNG



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,112)