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

Create HTML Table from Array of Strings

I read from a list column, whos value was 3 sets of JSON key pairs.  I split the text into an array and tried to create an HTML table but received an error message.  Does anyone who of a way to make this work?  Seems like I need to pass an array of objects, now strings. createHTML.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: Create HTML Table from Array of Strings

Hi @rarroyo1 

 

You are getting this error because the values inside the array is of type string and the Create HTML action requires key-value pairs.
Please follow the below screenshot and parse the returned response to get the values in a separate array and then pass it to the the Create HTML action.
 
In the Parse JSON function, pass the array that you have received as a string values.
Expression used to get the keys:
Split(items('Apply_to_each'),'"')[3]
Split(items('Apply_to_each'),'"')[7]
3 and 7 corresponds to the index of the values.MicrosoftTeams-image (64).png

 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

1 REPLY 1
Highlighted
Dual Super User III
Dual Super User III

Re: Create HTML Table from Array of Strings

Hi @rarroyo1 

 

You are getting this error because the values inside the array is of type string and the Create HTML action requires key-value pairs.
Please follow the below screenshot and parse the returned response to get the values in a separate array and then pass it to the the Create HTML action.
 
In the Parse JSON function, pass the array that you have received as a string values.
Expression used to get the keys:
Split(items('Apply_to_each'),'"')[3]
Split(items('Apply_to_each'),'"')[7]
3 and 7 corresponds to the index of the values.MicrosoftTeams-image (64).png

 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (5,939)