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
DeepakS
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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

 

 

DeepakS
Resident Rockstar
Resident Rockstar

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.

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

DeepakS
Resident Rockstar
Resident Rockstar

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,156)