cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sal
Helper III
Helper III

How to display values from two arrays into table format

Hi, 

I have two arrays with values, I want to display them in a table format with each value on new row line side by side but using union of arrays displaying all of the values in one big block. Can any one help? 

 

configurations.PNG

 

output.PNG

 

 
1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Sal 

 

here is a working example based on your arrays:

we need to format the array with Key ,value to make it work with html:

ArrayToHTML.png

 

-------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

7 REPLIES 7
DeepakS
Super User
Super User

Hi @Sal 

 

Could you please share how your arrays looks , it should be well formatted to get the correct results. 

 

Regards 

 

 

First array

[
"(Policy Provisions:",
"INSURER:",
"NCCI Company Number:",
"Company Code:",
"POLICY NUMBER:",
"Previous Policy Number:",
"1. Named Insured and Mailing Address:",
"FEIN Number:",
"The Named Insured is:",
"Business of Named Insured:",
"Other workplaces not shown above:",
"Producer's Name:",
"Producer's Code:",
"Total Estimated Annual Premium:",
"Policy Minimum Premium:",
"Audit Period:",
"Installment Term:",
"Process Date:",
"Policy Expiration Date:",
"__Tokens__"
]

 

second array

 

[
"WCOOOOOOC)",
"The Hartford Casualty Insurance Company",
"ONE HARTFORD PLAZA HARTFORD CT 06155",
"14397",
"3",
"72 WEC AB401D",
"New",
"Boguslawa Samsel",
"240 Jupiter Drive",
"Moon, Universe, 12345",
"31-0164468",
"Individual",
"Offices of Physicians (except Mental Health Specialists)",
"201 S LASKY DR",
"BEVERLY HILLS CA 90212",
"MESLEE INSURANCE SERVICES INC",
"LOS ANGELES CA 90046",
"72255996",
"THE HARTFORD BUSINESS SERVICE CENTER",
"3600 WISEMAN BLVD",
"SAN ANTONIO TX 78251",
"$1,569",
"$600 CA",
"ANNUAL",
"Ten Pay (25%Down+9@)8.33%)",
"04/13/18",
"04/13/19",
"INFORMATION PAGE",
"WORKERS COMPENSATION AND EMPLOYERS LIABILITY POLICY",
"THE",
"HARTFORD",
"Suffix",
"LARS RENEWAL",
"(No., Street, Town, State, Zip Code)",
"State Identification Number(s):",
"2. Policy Period:",
"From",
"To",
"12:01 a.m., Standard time at the insured's mailing address.",
"7164 MELROSE AVENUE",
"Issuing Office:",
"(877) 853-2582",
"Deposit Premium:",
"The policy is not binding unless countersigned by our authorized representative.",
"Countersigned by",
"Smeand. Castaneda",
"Authorized Representative",
"Date",
"Form WC 00 00 01 A",
"(1) Printed in U.S.A.",
"Page 1 (Continued on next page)"
]

 

 

In a html table I want to display 

Key                           Value (table headers)

(Policy Provisions:   WCOOOOOOC)

INSURER:                The Hartford Casualty Insurance Company

 

Thanks,

-Sal

 

 

Hi @Sal 

 

here is a working example based on your arrays:

we need to format the array with Key ,value to make it work with html:

ArrayToHTML.png

 

-------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Thanks, but I'm not able to see as the picture is very small, you may need break them into two three parts.

Hi Deepak, Thanks for the response but I'm not able to see what is been done to make it work, screenshot is too small.

 

Thanks,

-Sal

Hi @Sal 

 

I uploaded flow at 

https://github.com/DeepakS22/DPowerAutomate/blob/master/ArrayToHtml_20200331172110.zip

 

You can download and use it.

 

-------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Got it , Thank you.

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,290)