cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CheckMate
Resolver I
Resolver I

how do get the html from compose data from a array

Hi experts,

 

CheckMate_1-1627026076450.png

1. get list of item from SP list

2. append data to array

3. get the distinct values 

what should be the right way of doing point 4 ?

4. print into html table in an email, so that it prints like the following.

Column A, Column B

JELLYFISH,SANOFI

JELLYFISH,AUDI

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
CheckMate
Resolver I
Resolver I

anyway i found the solution, and simply i need to do is to add <br> to my array.

 

wasted 2 hours of my life.

 

CheckMate_0-1627037039315.png

 

View solution in original post

3 REPLIES 3
eric-cheng
Solution Sage
Solution Sage

Hi @CheckMate ,

 

You can pass the value of your get list to an array variable and then use the create HTML table action.  You can use the manual setting to specify your own table schema and mappings.

 

Use the table in your email body.

 

Screenshot_20210723-182313_Chrome.jpg

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

CheckMate
Resolver I
Resolver I

Thanks for trying, @eric-cheng  but that's not what I'm trying to achieve here.

my original SP list contains huge lines of data and by putting that into a html would be simply pointless.

 

so by doing the Union(), i am able to achieve the unique values, which which i am unable to find out which command is should be using to achieve the effect i want.

 

CheckMate_0-1627030968496.png

 

this prints out a single liner in an email.

["JELLYFISH,SANOFI","JELLYFISH,AUDI"]

 

which the better output display is to format into this final..

JELLYFISH,SANOFI

JELLYFISH,AUDI

 

 

 

 

CheckMate
Resolver I
Resolver I

anyway i found the solution, and simply i need to do is to add <br> to my array.

 

wasted 2 hours of my life.

 

CheckMate_0-1627037039315.png

 

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,469)